Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
az38
Community Champion
Community Champion

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!


do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn
1 ACCEPTED SOLUTION
Sean
Community Champion
Community Champion

@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

View solution in original post

2 REPLIES 2
Sean
Community Champion
Community Champion

@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

az38
Community Champion
Community Champion

Perfect! it was so easy, Im ashamed Smiley Embarassed

Thank you


do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors