Forum Discussion

Snagalapur's avatar
Snagalapur
Icon for Helper IV rankHelper IV
1 year ago
Solved

Format code for Cards to show in Millions

hi All,

 

Please suggest format code for Cards to show in Millions.

 

 

7 Replies

  • hi Snagalapur ,
    To format a card visual in Power BI to display values in millions, you can use the following custom
    Option 1
    format code:

    #,, "M"

    Option 2
    select the 
    card visual > Format > Data label > Display unit In this way, we can format our display unit to auto, none, thousand, million,etc.

    I hope the provided solution works for you

    If I have resolved your question, please consider marking my post as a solution. Thank you!
    A kudos is always appreciated—it helps acknowledge the effort and keeps the community thriving.

    • Snagalapur's avatar
      Snagalapur
      Icon for Helper IV rankHelper IV

      thank you for suggesting. could you please help on below format for thousand separator 

       

      • grazitti_sapna's avatar
        grazitti_sapna
        Icon for Super User rankSuper User

        Hi Snagalapur ,

        To Show in Thousands

        #,##0, "K"

        I hope the provided solution works for you

        If I have resolved your question, please consider marking my post as a solution. Thank you!
        A kudos is always appreciated—it helps acknowledge the effort and keeps the community thriving.