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

[Anonymous]

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!

[Anonymous]

Screenshot went missing from my last post

[blopez11 · 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,

[TedemanCPA]

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]

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]

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

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

[blopez11]

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