Forum Discussion

SantoshKumar's avatar
SantoshKumar
Microsoft Employee
5 years ago
Solved

How to Create Color coded Table which has all measures as Values to show in the Table.

Hi All, I want to show a color code table in my power bi report which has all measures as values as below:    ex: Measure1 is the name of the measure and 10 is the result of the measure i tried t...
Need Help
Show and Tell
Tips and Tricks
  • Pragati11's avatar
    Pragati11
    5 years ago

    Hi SantoshKumar ,

     

    Not sure why it's not working at your end. I tried at my end using CARD visual for these 3 measures along with Text Boxes to label them on the left and they work pretty well:

    You can modify background colours, text size, etc. based on your requirement.

     

    How many measures do you have?

     

    Thanks,

    Pragati

Pragati11's avatar
Pragati11
Super User
5 years ago

HI SantoshKumar ,

 

Can you share some sample data along with screenshots on what is the desired output?

 

Thanks,

Pragati

SantoshKumar's avatar
SantoshKumar
Microsoft Employee
5 years ago

Pragati11 i have attached the snapshot but unfortunately it is not showing once i submitted the post.

below is the snapshot which is the expected table.

  • Pragati11's avatar
    Pragati11
    Super User
    5 years ago

    Hi SantoshKumar ,

     

    Is this really an expected output? I mean you don't have any columns in this table just the measures. Is that right?

    If it is just measures,

    1. create individual card visuals for each of your measures - you will have like 5 cards
    2. Give required backgound color to these card visuals
    3. Add text boxes to give name for your masures
    4. Give required colours for these text boxes as well
    5. stack all of these text boxes and card visuals on top of each other 

    Thanks,

    Pragati

    • SantoshKumar's avatar
      SantoshKumar
      Microsoft Employee
      5 years ago

      Pragati11  Yes , my requirement consists of only measure. i have already tried scorecards and text boxes but it is not looking good when its viewed and i thought there could be some other options to represent my data in more convenient way.

      • Pragati11's avatar
        Pragati11
        Super User
        5 years ago

        Hi SantoshKumar ,

         

        Not sure why it's not working at your end. I tried at my end using CARD visual for these 3 measures along with Text Boxes to label them on the left and they work pretty well:

        You can modify background colours, text size, etc. based on your requirement.

         

        How many measures do you have?

         

        Thanks,

        Pragati

  • AllisonKennedy's avatar
    AllisonKennedy
    Community Champion
    5 years ago

    SantoshKumar  Would using a matrix visual with 'show values on rows' work for your requirements?