Forum Discussion
Solved
Hierarchy based text conditional formatting
Hi Power Bi Experts, I want to display the grand total text values into red, Region total into blue & Mine total black. As this is hierarchy in rows. How we can do it based conditional formatting...
Hi prakash11440278 ,
Sorry to disturb you...
But did I answer your question ? Please mark my reply as solution. Thank you very much.Best Regards,
Stephen Tao
prakash11440278 , You have to create a color measure with isinscope and use that in conditional formating with field value option
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
isinscope
https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/