cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
az38 Regular Visitor
Regular Visitor

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!

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Percent in visuals

@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! Smiley Happy

2 REPLIES 2
Super User
Super User

Re: Percent in visuals

@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! Smiley Happy

Highlighted
az38 Regular Visitor
Regular Visitor

Re: Percent in visuals

Perfect! it was so easy, Im ashamed Smiley Embarassed

Thank you