Forum Discussion

vjnvinod's avatar
vjnvinod
Icon for Impactful Individual rankImpactful 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

3 Replies

  • 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