Forum Discussion
Conditional formatting - color scale on different row
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 ther...
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
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 ...
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.