How to format a matrix table

[AnandNamburi]

Hi Experts,

I have a matrix table and it look like below.

Column1	Column 2	Column 3
Furniture	Chair	123
	Table	254
	Sofa	500
Beauty	Soaps	587
	Shampoos	300
	xxx	458
Mobiles	Samsung	158
	Honoe	458
	Oppo	977

Now my requirement is to format like below.

When I enabled Matrix my column 1 is in rows and not in Values . That's why I'm not able to achieve this directly.

Is there any work around for this.

Thanks,

Anand

[v-rzhou-msft]

Hi @AnandNamburi 

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file from your Onedrive for Business.

Best Regards,

Rico Zhou

[v-rzhou-msft · Accepted solution]

Hi @AnandNamburi 

You may want to use conditional formmatting for row headers in matrix visual.

I build a color measure and have a test.

Measure:

Measure = IF(MAX('Table'[Column1])="Furniture",1,IF(MAX('Table'[Column1])="Beauty",2,3))

Set conditional formatting in Background by Rules.

We can use conditional formmatting to format the color in value fields in matrix visual.

For more info to conditional formmatting, you may refer to this blog.

Your demand is a good idea, while it is not supported to implement in Power BI currently.

You can vote up this idea for this function：Conditional Formatting of Row Headers in Matrix

Or you can submit a new idea to improve the Power BI.
It is a place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.