Avoiding whole number displaying as Scientific Notation in Power BI Dashboard

[anshpalash]

Hi all,

I have a whole number type column in my power bi desktop. There, the number showing is the actual number, not scientific notation. However, when I display it on a dashboard in a note card, it is showing in scientific notation, which I do not want.

Can someone please help me and advise how to get the actual number in dashboard visuals here?

[v-janeyg-msft · Accepted solution]

Hi,  @anshpalash 

After my test, If the format is set to 'scientific', then you change the displays units in the card to none won't work, you need to change the format to 'whole number' first.

Like this:

Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.

Best Regards,

Community Support Team _ Janey

[Anonymous]

Best way is to use a Multi Row Card for this Scenario.
If the Result Set Displays 1.22e-8 add 10 decimal places for the number and use a multi row card. 

[Greg_Deckler]

@anshpalash Try going to the Format sub-pane of the Visualizations pane and expand Data label section and change the Display units to None.

[anshpalash]

@Greg_Deckler I did that, but that does not change anything. It is still displaying in scientific notation

[Greg_Deckler]

@anshpalash Maybe try a Custom Format String. I believe that overrides a lot of automatic formatting.