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

Hi Anonymous , to highlight entire rows including the 'Total' column in a Power BI matrix or table, set conditional formatting on each field and ensure the "Apply to" option is set to "Values and Totals". Update your formatting rules to also include totals so that all cells, including row totals, reflect the highlight color.