Forum Discussion

Leo0271's avatar
Leo0271
New Member
2 months ago
Solved

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.    
  • govind_021's avatar
    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.

  • danextian's avatar
    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

     

  • Poojara_D12's avatar
    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.