Show values as whole thousands

[Pragati]

 Hi, Is there a way to format visuals or tables to have the numbers shown in whole thousands. Example in below graph it should display Count of UniqueConfID as 61392 on top instead of 61k. As the values are not displayed as a whole in powerpoint

[prateekraina · Accepted solution]

Hi @Pragati,

Go to Data labels in Format pane of the visual and set Display units to None

Refer below screenshot:

Prateek Raina

[rosirosss]

@prateekraina Do you know how this can be done in an Infographic visual? i dont seem to find that option available

[prateekraina]

Hi @rosirosss,

Check out this video. You will understand the steps to achieve that.

Prateek Raina

[rosirosss]

@prateekraina thank you for your response. I watched the video but did not find what i was looking for. On the bar chart the data label is shown as 1.3 M or 2.4K. But i wanted it to be shown as 1,300,000 or 2,400. 

I achieved what i wanted by adding a new measure. But I was hoping that infographic visual has some setting like the card with states visual (as you showed in your screen shot above) where you can format the data label.

here is the measure i created - this will give me the metric value as 16,252 instead of 1.6 K

MetricValueFormatted = FORMAT(sum(BPAT_Source[MetricValue]),"#,0")

[prateekraina]

@rosirosss

My bad, i should have watched that video in full screen mode :D.

Anyways since you have already found the workaround, its great.

There is no straight forward option in the format pane of this visual as i have shown in the earlier screenshot.

Prateek Raina