Forum Discussion

vjnvinod's avatar
vjnvinod
Impactful Individual
8 years ago

power Bi CARD

hi,   How do we format Power BI card visuals to Millions or billions based on our requirment. I don't find any option to do so.   Please suggest if there is a way to do it.
Need Help
Show and Tell
mikez2605's avatar
mikez2605
Regular Visitor
8 years ago

Under formatting for the card, try changing the Display Units field (under Data Label)?

 

Before:

 

 

 

 

 

 

 

 

 

 

 

 

After:

    • mikez2605's avatar
      mikez2605
      Regular Visitor
      8 years ago

      I see you're using a multi row card, whereas I was using a card, which explains the difference. Looks like that formatting option isn't available for multi row cards. I would recommend creating 6 different cards and set the format individually.

       

      Otherwise, you could create a measure similar to the below:

       

      "=CONCATENATE(TRUNC([value name])/1000000,2),"M")" (for millions)

      You'd have to do this for each data point however, so it's not an ideal solution