Forum Discussion
Color rows based on a measure
Dear Community,
I have a measure, which called TEMP, and has 3 values, -1,0,1,
I want to color rows of below matrix based on TEMP, when TEMP=1 rows goes to green, when TEMP=0, rows yellow and etc.
but the issue is that I do want to show TEMP to be in the matrix, just S and C are in the matrix, Is this possible?
Thanks in advance.
Anonymous use the table visual not matrix
9 Replies
Anonymous use the table visual not matrix
parry2k Thanks for you help, I changed it to table and now it works, I just have another question,
by changing, S and C are next to eachother horizontaly, but my ideal table is to S and C stand vertically.this is what I got:
what I want is to : C goes to under S, vertically.
Anonymous in that case you need to unpivot your table in the Power Query.
parry2k Could you please help me how? Or give me proper link?
parry2k this does not work in my case because C and S are both 2 different column from 2 different tables.
Anonymous yes it can be done, set the conditional formatting for this column and then use temp column (need to create a measure) for the color.
Check my latest blog post Year-2020, Pandemic, Power BI and Beyond to get a summary of my favourite Power BI feature releases in 2020
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
Anonymous
This is done in case S or C are in the values, the problem is that S and C are in Rows, and they do not have option of conditional formatting.