Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to 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
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
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.
@anshpalash Try going to the Format sub-pane of the Visualizations pane and expand Data label section and change the Display units to None.
@Greg_Deckler I did that, but that does not change anything. It is still displaying in scientific notation
@anshpalash Maybe try a Custom Format String. I believe that overrides a lot of automatic formatting.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
94 | |
82 | |
66 | |
59 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |