Vertical Bar chart showing numbers in Billions when published to a workspace

[Anonymous]

I have created a Vertical Bar Chart with a Dimension and a measure. 

The display units is set to 'Auto' , since the sheet contains so many other filters. 

It is showing the numbers correctly in 'Millions' when in PowerBI desktop.

However when it is published to a Workspace (Organizational) and then published to APP it is showing in 'Billions', which is very awkward.

How Can I keep it in Millions itself.

[v-danhe-msft · Accepted solution]

Hi @Anonymous ,

You could set the Display uints as million and it could work on my side:

Desktop:

Service:

Regards,

Daniel He

[Anonymous]

By default it should show 'Millions'. [ Prsently it is in Billions ]

however It should be set as 'Auto'., since there are so many dropdown filter visuals in this sheet. hence based on the selection the units should show Millions, or Thousands etc..

If we set it to Millions, even in the granular level of filtering it will show 0.00M which may not be accurate.

In any case it should not show Billions, since the figures are not high enough to display it as Billions.