What is the best way to add a data bar on the Sub-total column only in a Matrix Visual?

[iamriz]

In one matrix visual, is it possible to add a data bar on the Sub-total column only, while having a different conditional (highlight) formatting on the table values?

Attached is the sample data table I want to achieve. 

https://drive.google.com/file/d/10gAnqodqkg_ZPc_SIgzI4YZo9PylGNyR/view?usp=sharing

Kindly advise. Thank you very much for all the help.

[v-shex-msft · Accepted solution]

Hi @iamriz,

For conditional formatting 'data bar' mode, it does not support advanced customize and it is impossible to only apply on sub-total level.

Use conditional formatting in tables 
If you use other modes, you can write a measure formula to check two contents levels to return specific color, then you can use this as filed value to highlight the subtotal level records.

Regards,

Xiaoxin Sheng

[Fowmy]

@iamriz 

You can apply background Color, Font Color, and Icons to Column Total and Row Total. You need to choose Total only under Apply To. You Values can have different CF.

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

Click on the Thumbs-Up icon on the right if you like this reply 🙂

YouTube, LinkedIn