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

how to get rid of decimal for avg rating?

 

Capture.PNG

How to change Average rating to 2 decimal point. i attached screen shot also. when i hover my mouse to graph it showing 4.7272727272227275. i want to show only two decimal point whenever mouse move over to graph like (4.72).

 

3 REPLIES 3
Greg_Deckler
Super User
Super User

In your data model, click on your column or measure. See screen shot of ribbon below:

 

powerbi1.png


@ me in replies or I'll lose your thread!!!
Check out my External Tool for Power BI Desktop!
Microsoft Hates Greg's Quick Measures
Check out my latest book!

Thanks for Reply, Its worked in Desktop as i expected. I am looking into the web, instead of Desktop. Is there any option we can in Web?

Not that I am aware of at this time. You really do not have much control over the data model and formatting in the Service.


@ me in replies or I'll lose your thread!!!
Check out my External Tool for Power BI Desktop!
Microsoft Hates Greg's Quick Measures
Check out my latest book!

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors