Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
Any tips to change the background color of my rows in a matrix depending values ?
regards
Solved! Go to Solution.
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
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
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
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi, @nkasdali
Could you please tell me whether your problem has been solved?
If yes, you could accept the helpful answer as solution. You could also share your own solution here.
For now, there is no content of description in the thread. If you still need help, please share more details to us.
Best Regards,
Community Support Team _ Eason
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
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
@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-num...
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values
@nkasdali , It works in the same manner. In Matrix, you can color only values, not rows(pivot) and columns.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |