Forum Discussion

az38's avatar
az38
Community Champion
7 years ago
Solved

Percent in visuals

Hello!

 

I have a Decimal Number column in my data source. After import data i change type to percent. In the query editor i see correct format but after applying changes, column in the Data grid and visuals has a Decimal number format. whats the correct way to change data type?

 

Thx for attention!

Need Help
  • Sean's avatar
    Sean
    7 years ago

    az38Yes its important you set the correct Data Type in the Query Editor!

    However Formatting in the Query Editor does not affect the Formatting in the Data View.

    So with the column selected go to the Modeling tab in the Data View and then set the Formatting there!

    Hope this helps! :smileyhappy:

2 Replies

  • Sean's avatar
    Sean
    Community Champion
    7 years ago

    az38Yes its important you set the correct Data Type in the Query Editor!

    However Formatting in the Query Editor does not affect the Formatting in the Data View.

    So with the column selected go to the Modeling tab in the Data View and then set the Formatting there!

    Hope this helps! :smileyhappy:

    • az38's avatar
      az38
      Community Champion
      7 years ago

      Perfect! it was so easy, Im ashamed :smileyembarrassed:

      Thank you