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 ,

 

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.