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

[SantoshKumar]

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 

[Pragati11]

HI @SantoshKumar ,

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

Thanks,

Pragati

[SantoshKumar]

@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.

[AllisonKennedy]

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

[Pragati11]

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]

@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 · Accepted solution]

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

[SantoshKumar]

 @Pragati11 

Hi Pragati,

I have not said like it is not working but its looks like kind of messy because per now i have  5measure, 5 text boxes which i have to show in smaller boxes in size, then need to align, next have to group them to move across the page.
if any changes required then have to ungroup them and follow the process.
instead of this i was looking for any visual which can be available to make it simplier.

Regard

Santosh

[Anonymous]

Hi @SantoshKumar,

Can you please share some dummy data, snapshots, and expected results to help us clarify your requirements?

How to Get Your Question Answered Quickly 
Regards,

Xiaoxin Sheng

[Pragati11]

Hi @SantoshKumar ,

Actually if you use any visual, it will be hard to change colours on the value and label both.

I will see if I can find some visual. But for now this is the only way I can suggest.

Let's see if someone else comes up with a better idea. 🙂

Thanks,

Pragati