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)
MasonMA's avatar
MasonMA
Icon for Super User rankSuper User
1 year ago

Hello Anonymous 

If you just wanted to highlight the bottom row (the Row Grand total) without highlighting the entire Column Grand Total, i dont see there's a direct way to set this up in Format Panel. You would need to use a simple Measure for conditional formatting. 

ColorFlag =
IF( NOT ISINSCOPE(Table[Category]), 1, 0)
so that For the Grand Total row at the very bottom, 'Category' (Rows in my demo table) is no longer in scope, so it returns 0

 

 

Hope this helps:) 

  • 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