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
harsha1234
Regular Visitor

Rounding the value of a measure

Hi all,

 

I am trying to create a card with the percent of completions, and I'd like to round to the nearest whole number. 

 

This is what I have right now:

 

Percent Complete = ROUND(DIVIDE('table'[completed],'table'[alle])*100,0)

 

After using this measure, I get for example: 85.00

 

How I can I get rid of the 0's at the end and if possible put a '%' sign after the value? So I'd like it to read: 85%

 

Thanks in advance!!

H

1 ACCEPTED SOLUTION
synergised
Resolver II
Resolver II

Visual formating is under the Modeling tab.

 

.85 then apply the % and set the decimal places.. in your case to 0.

 

modeling.png

View solution in original post

3 REPLIES 3
jxutj
Regular Visitor

The UI has changed. Now it's under Visualizations sidebar > Format your visual (paintbrush) > Callout value > Value decimal places

BKirsch12
Resolver II
Resolver II

Select the measure on the fields pane on the right. Then under modeling, use thes formatting section:BI Menu.PNG

 

 

You may need to adjust your measure fro 85 to display as 85% as opposed to 8500%.

 

 

 

 

synergised
Resolver II
Resolver II

Visual formating is under the Modeling tab.

 

.85 then apply the % and set the decimal places.. in your case to 0.

 

modeling.png

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.