topic Re: Format a New Measure into Percentage with 2 decimal places on a Line and Stacked Column Chart in Desktop

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

Anonymous — Wed, 26 Oct 2016 19:33:04 GMT

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!

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

Anonymous — Wed, 26 Oct 2016 19:34:57 GMT

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.

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

Anonymous — Wed, 26 Oct 2016 19:39:53 GMT

Screenshot went missing from my last post

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

blopez11 — Wed, 26 Oct 2016 19:43:51 GMT

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,

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

Anonymous — Wed, 26 Oct 2016 19:47:44 GMT

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

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

blopez11 — Wed, 26 Oct 2016 19:51:01 GMT

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

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

TedemanCPA — Sat, 09 Dec 2017 18:04:16 GMT

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 :-)