Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to Solution.
Visual formating is under the Modeling tab.
.85 then apply the % and set the decimal places.. in your case to 0.
The UI has changed. Now it's under Visualizations sidebar > Format your visual (paintbrush) > Callout value > Value decimal places
Select the measure on the fields pane on the right. Then under modeling, use thes formatting section:
You may need to adjust your measure fro 85 to display as 85% as opposed to 8500%.
Visual formating is under the Modeling tab.
.85 then apply the % and set the decimal places.. in your case to 0.
User | Count |
---|---|
128 | |
109 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |