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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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