Forum Discussion
number format help
- 2 months ago
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.
Best Regards
Govind Sapkade ( Microsoft Certified Data Analyst , PL 300 Certified , MS Fabric Enthusiast)
Let's Connect
Linkdin - www.linkedin.com/in/govind-sapkade-845104225
Youtube - http://www.youtube.com/@govind_dataanalyst - 2 months ago
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
- 2 months ago
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.
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.
Govind Sapkade ( Microsoft Certified Data Analyst , PL 300 Certified , MS Fabric Enthusiast)
Let's Connect
Linkdin - www.linkedin.com/in/govind-sapkade-845104225
Youtube - http://www.youtube.com/@govind_dataanalyst