Alternate row color

[JofrainVisda]

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!

[Anonymous]

Hi @JofrainVisda ,

You may consider to submit this as an idea.

https://ideas.powerbi.com/ideas/ 

Best Regards,

Jay

[JofrainVisda · Accepted solution]

Just did man. Thanks!

[Juliet1]

Hi JofrainVisda

How were you able to solve this? I am running into the same issue.

I will appreciate if you can help me

[amitchandak]

@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]

I see. So there is no straight forward solution to this. Thanks man!