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

MFelix's avatar
MFelix
Super User
5 years ago

Hi prakash11440278 .

 

you need to create a measure similar to this one:

Formatting = SWITCH(
                  TRUE();  
                  ISINSCOPE('Table (2)'[Mine]);"black";  
                  ISINSCOPE('Table (2)'[Region]); "blue"; 
                  "Red"
                   )

 

Be aware that the order of the parameters is important for the final resutl

prakash11440278's avatar
prakash11440278
Post Prodigy
5 years ago

Hi MFelix mahoneypat amitchandak ,

 

Thanks for your reply.

 

I have replicated in my report it is working fine except the total part, which the font colors are not coming as expected.

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi prakash11440278 ,

     

    Based on my test, you could set the colors of Grant total and Subtotals separately. In Subtotals, they can no longer be divided.

     

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.