cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Format a New Measure into Percentage with 2 decimal places on a Line and Stacked Column Chart

See screenshot below. I created a new measure called NP% = (count('Scheduled and Arrived Appts'[New Patient Appts]) / count('Scheduled and Arrived Appts'[Appt Scheduled])) * 100. When that measure is put into a Line and Stacked Column chart, the data label shows too many decimal points. How can I get the data label to show only 2 decimal points?

 

Thanks in advance!

 

1 ACCEPTED SOLUTION

Instead of multiplying by 100, go to the data view, select your measure, then select the Modeling tab, then in the Formatting section, select the % icon, then select the # of digits,

View solution in original post

6 REPLIES 6
Anonymous
Not applicable

Screenshot went missing from my last post

 

formatting percentage in a a New Measure.jpg

 

 

 

 

 

 

Instead of multiplying by 100, go to the data view, select your measure, then select the Modeling tab, then in the Formatting section, select the % icon, then select the # of digits,

View solution in original post

Thanks for this note -- Yep, in my case, the Format options were not available from Report View.

 

From Data View however, you just select the measure from the Fields Pane and -- viola -- the Format options are active 🙂

Anonymous
Not applicable

I think when you use visual e.g stack bar chart and choose format -> data label -> on

The % will show as well as actual figure.

Hope this works for you.

Anonymous
Not applicable

Is there any way to add a % sign to the data label?

 

Can I add % to the data label in Power BI?Can I add % to the data label in Power BI?

 

format data label in power bi.png

 

 

If you change the formatting as I specified above, the % sign will show up

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Top Solution Authors
Top Kudoed Authors