Forum Discussion
number format help
I want to change the format of the numbers so that they appear in full and not summarized, and I can't find a way to do it.
In Microsoft Power BI, if you want the numbers in a Card visual to appear in full instead of summarized values like 1K or 1M, select the Card visual first and then go to the Format pane (paint roller icon). Open the “Callout value” section and find the “Display units” option. By default it is usually set to Auto, which summarizes the numbers. Change it to “None”. After doing this, the Card will display the complete number such as 1,500,000 instead of 1.5M. You can also adjust the decimal places if needed.
If you're using the new card visual, go to callout section, select the measure from the dropdown and change the display units to none
For the old car visual, also change the display units to none
Hi Leo0271
To show the full numbers instead of auto-summarized values (like "mil" or "mill.") in your card visuals, you need to change the display units setting in the formatting pane. Select the visual you want to change, go to the Format visual pane on the right (the paintbrush icon), expand the Callout value section, look for the Display units dropdown menu, and change it from "Auto" to "None". If you are using the new multi-row card or KPI cards, you can find this exact same setting by navigating to Format visual > Values > Display units and switching it to "None" to force Power BI to display every single digit.
5 Replies
If you're using the new card visual, go to callout section, select the measure from the dropdown and change the display units to none
For the old car visual, also change the display units to none
In Microsoft Power BI, if you want the numbers in a Card visual to appear in full instead of summarized values like 1K or 1M, select the Card visual first and then go to the Format pane (paint roller icon). Open the “Callout value” section and find the “Display units” option. By default it is usually set to Auto, which summarizes the numbers. Change it to “None”. After doing this, the Card will display the complete number such as 1,500,000 instead of 1.5M. You can also adjust the decimal places if needed.
Hi Leo0271,
Thank you for reaching out to the Microsoft Fabric Community Forum. Also, thanks to danextian, govind_021, for those inputs on this thread.Has your issue been resolved? If the response provided by the community member danextian, govind_021, addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.
Hope this helps clarify things and let me know what you find after giving these steps a try happy to help you investigate this further.
Thank you for using the Microsoft Community Forum.Hi Leo0271,
Just wanted to follow up. If the shared guidance worked for you, that’s wonderful hopefully it also helps others looking for similar answers. If there’s anything else you'd like to explore or clarify, don’t hesitate to reach out.Thank you.
Hi Leo0271
To show the full numbers instead of auto-summarized values (like "mil" or "mill.") in your card visuals, you need to change the display units setting in the formatting pane. Select the visual you want to change, go to the Format visual pane on the right (the paintbrush icon), expand the Callout value section, look for the Display units dropdown menu, and change it from "Auto" to "None". If you are using the new multi-row card or KPI cards, you can find this exact same setting by navigating to Format visual > Values > Display units and switching it to "None" to force Power BI to display every single digit.
