Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Power BI - Entire rows highlight

How to highlight entire rows in power BI and I try to highlight but column 'Total' not able to do in metrics table. even 43 should be green color any suggestion.  
Need Help
  • MasonMA's avatar
    MasonMA
    1 year ago

    Anonymous 

     

    That would be the code below . 

    ColorFlag =
    IF( NOT ISINSCOPE(Table[Category]), 1, 0)
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Its works as if Sub-total level of data like below but I need 'Total' entire rows 'color'

example:

Food

proteins

vitamin

minerls 

Household

furniture

tools

Total 0000          2120        3030   4040  5050

 

 

 

 

MasonMA's avatar
MasonMA
Icon for Super User rankSuper User
1 year ago

Anonymous 

 

This all depends on Which filter contexts you wanted them to be 'In Scope'. 

For example, if i tweak the DAX to below, both Subtotal and Grand Total are highlighted (except for null values)

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    In Metrics table I would need 'Total' (In the last rows)

    suggest

    • MasonMA's avatar
      MasonMA
      Icon for Super User rankSuper User
      1 year ago

      Anonymous 

       

      That would be the code below . 

      ColorFlag =
      IF( NOT ISINSCOPE(Table[Category]), 1, 0)
      • v-menakakota's avatar
        v-menakakota
        Icon for Community Support rankCommunity Support
        1 year ago

        Hi Anonymous  , 

        Thanks for reaching out to the Microsoft fabric community forum. 

         

        I would also take a moment to thank MasonMA  , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference. 

        Best Regards, 
        Community Support Team