Forum Discussion

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 to use scorecards, multiplescorecard etc but did not get the expected results.

please suggest any solutions if you haveAny suggestions

Regards

Santosh

Tips and Tricks

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

9 Replies

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
  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
    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,
    
    create individual card visuals for each of your measures - you will have like 5 cards
    
    Give required backgound color to these card visuals
    
    Add text boxes to give name for your masures
    
    Give required colours for these text boxes as well
    
    stack all of these text boxes and card visuals on top of each other
    
    Thanks,
    
    Pragati