Forum Discussion
Alternate row color
Hi friends,
Is it possible in pbi to set the alternate background color using the highest level of detail instead of lowest ones? The metric column is in the rows shelf as well as the TeamName and Team Owner while the Target is in the value shelf.
I want it to be this way. The whole row of Actuation Technologies - Reports Analytics will be color gray until Metric Volume and target 0. Then next row after that will be white until Metric Volume and target 0. Thank you in advance!
Just did man. Thanks!
5 Replies
- amitchandak
Super User
JofrainVisda , I doubt that is possible. You can do this using background conditional formatting using color measure. but getting the logic you want in DAX would be challenge
refer if needed
How to do conditional formatting by measure and apply it on pie?: https://youtu.be/RqBb5eBf_I4
- JofrainVisda
Advocate I
I see. So there is no straight forward solution to this. Thanks man!
- AnonymousNot applicable
Hi JofrainVisda ,
You may consider to submit this as an idea.
https://ideas.powerbi.com/ideas/
Best Regards,
Jay
- JofrainVisda
Advocate I
Just did man. Thanks!
- Juliet1Frequent Visitor
Hi JofrainVisda
How were you able to solve this? I am running into the same issue.
I will appreciate if you can help me