Power BI - Entire rows highlight

[Anonymous]

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.

[Shahid12523]

Apply to Values and Totals

[Anonymous]

@Shahid12523  -

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

[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 0

Hope this helps:) 

[Anonymous]

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]

@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]

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

suggest

[MasonMA · Accepted solution]

@Anonymous 

That would be the code below . 

ColorFlag =

IF( NOT ISINSCOPE(Table[Category]), 1, 0)

[v-menakakota]

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]

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  

[v-menakakota]

Hi @Anonymous ,

Can you please confirm whether the issue is sorted or not?

Thank you.

[Shubham_rai955]

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.