Forum Discussion
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.
Anonymous
That would be the code below .
ColorFlag =IF( NOT ISINSCOPE(Table[Category]), 1, 0)
11 Replies
Shubham_rai955Super User
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.
- MasonMA
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 0Hope this helps:)
- MasonMA
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)
- Shahid12523
Community Champion
Apply to Values and Totals
I applied conditional formatting as following obervation.
'Denmark' entire rows = white color should not highlight
"Total" rows only = any color, i.e. green, purple
any suggestion
