Forum Discussion
Conditional formatting for Rows
Hi All,
Any tips to change the background color of my rows in a matrix depending values ?
regards
Hi, nkasdali
Please check the link down below.
I am not sure whether I understood your request correctly, but I created a ranking measure for <segment ranking by sales> for country & product.
And I put this measure into the background conditional formatting option pane.
https://www.dropbox.com/s/nh5dev64dy84v52/CF%20rows2.pbix?dl=0
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: linkedin.com/in/jihwankim1975/
Twitter: twitter.com/Jihwan_JHKIM
7 Replies
- amitchandakSuper User
nkasdali , You can color a row. You can color values. That to one by one. Create a color measure and use that for all values . Conditional formatting -> advance -> field value
example
Measure =
Switch(true(),
max(Table[status]) = "In production" , "Red" ,
max(Table[status]) = " Product completed" , "Green" ,
"blue "
)color Measure =
Switch(True() ,
max(Table[ID]) in {10,20,30} ,"Red",
max(Table[ID]) in {5,15,25} ,"Blue",
"White"
)refer my video: https://www.youtube.com/watch?v=RqBb5eBf_I4
or these for steps
https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-numbers-in-the-column
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values- nkasdaliMicrosoft Employee
thanks amitchandak but in your exemple you're using a TABLE not a Matrix.
- amitchandakSuper User
nkasdali , It works in the same manner. In Matrix, you can color only values, not rows(pivot) and columns.
- Jihwan_KimSuper User
Hi, nkasdali
I am not sure if I understood your question correctly, but in some cases, row-based conditional formatting is possible in a matrix visualization, by creating a rankx measure and use it as a conditional formatting measure.
If it is OK with you, please share your sample pbix file's link here, then I can try to look into it to come up with a relevant solution.
Thanks.
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: linkedin.com/in/jihwankim1975/
Twitter: twitter.com/Jihwan_JHKIM
- nkasdaliMicrosoft Employee
Jihwan_Kim here a pbix file PBIX files thanks
- Jihwan_KimSuper User
Hi, nkasdali
Please check the link down below.
I am not sure whether I understood your request correctly, but I created a ranking measure for <segment ranking by sales> for country & product.
And I put this measure into the background conditional formatting option pane.
https://www.dropbox.com/s/nh5dev64dy84v52/CF%20rows2.pbix?dl=0
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: linkedin.com/in/jihwankim1975/
Twitter: twitter.com/Jihwan_JHKIM