Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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
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
@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 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |