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 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:
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
6 Replies
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
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!
