Conditional formatting - color scale on different row

[Anonymous]

Hi all,

I am trying to do conditional formatting on each row of the following matrix table

for each KPI. However, since by default, Power BI treats KP1_1 and KP1_2 on a same color scale

Is there a work around to set conditional formatting for each row/ each KP1?

Thank you.

Conditional formatting on different rows but not color scale:

https://community.powerbi.com/t5/Desktop/Conditional-formatting-on-Rows/td-p/550047

open idea posted looks similar to my question: 

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/32280310-matrix-conditional-forma...

[Anonymous · Accepted solution]

First, consider this table structure: 

Then, take a look at this post, make sure you select values, show on rows,

then you will be able to set conditional formatting for 'each row'

https://datasavvy.me/2017/08/10/you-can-now-put-values-on-rows-in-power-bi/

Finally, you should be able to set conditional formatting for different row

[Izzy]

Hi @Anonymous ,

Did the accepted solution solve your problems? I have switched the "Show on rows" as "ON" in Values, but nothing gonna be changed in my martix. How can I have the color scale on different rows?

For my sample, there are no timestamp, what I have got are the products and retailers and their prices.

Neeeeeed Help!

[Anonymous]

Hope these screenshots would help you:

data structure

choose conditional formatting for each row

Make sure you select show on rows

[Izzy]

Hi @Anonymous,

Thank you for your reply.

And my table structure is a little bit different from yours.

Such as this. Do you have any idea to deal with it? I really appreciate your support and help

[Anonymous]

Looks like you are trying to create a table similar to a cross join table, every possible retailer for each product. I doubt  this kind of table structure will allow you to do conditional formatting for each product ... 

[Izzy]

Thats the problem.

What I am thinking is how to handle this, cause it can work well for a single product for multiple retailers.

Do you have any idea. It blocked me for nearly a week.