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

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  

      • v-menakakota's avatar
        v-menakakota
        Icon for Community Support rankCommunity Support
        1 year ago

        Hi  Anonymous ,

        I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you.

        Best Regards, 
        Community Support Team