Forum Discussion

prakash11440278's avatar
prakash11440278
Post Prodigy
5 years ago
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...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    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

mahoneypat's avatar
mahoneypat
Microsoft Employee
5 years ago

You could use a measure expression like this in the text conditional format to do that.  Replace table with your actual table name.

 

Text Color = IF(ISFILTERED(Table[Mine]), "Black", IF(ISFILTERED(Table[Region]), "Blue", "Red")

 

Regards,

Pat