We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

How to change the column data type in dashboard designer?

Platform: Dashboard Platform |
Control: Dashboard Datasources

Use Case Scenario: If you want to use any measure (or numeric) based column as dimension (or label), based column, then you can follow this approach.

In-order to change the column data type, please follow the below steps.

1) Select a particular column and click on the settings icon. A context menu now appears in which you need to select “Change Column Type” option.

C:\Users\satheesh.kalimuthu\Desktop\Change column type1.png


2) For instance, if you want to change integer data type to string then select “Text” option from the context menu.



3) Once you change the column data type from integer to string, the changed column will act as string throughout the dashboard designing stages, until you change it to any other datatype or default datatype.


4) Now the changed column can be used in the widgets. Since the column is changed to string data type, the column gets displayed under Dimension” section of control designer and you can configure in widgets accordingly. NOTE: If you have set the column data type as integer, then the column would have been listed under “Measures” section of control designer.




5. The following table represents the column data types and their equivalent convertible data types that are supported in our Dashboard Designer.

Column Data Type

Convertible Data Types


DateTime, Text


Decimal, DateTime, Text


Decimal, Text


DateTime, Decimal



You must log in to leave a comment

Please sign in to access our KB

This page will automatically be redirected to the sign-in page in 10 seconds.

Up arrow icon

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

Live Chat Icon For mobile