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.
I need help in formatting issues regarding grand totals
1) I want column grand total background color as yellow but the row grand total will be different color. When I tried it in formatting, the same background color applies to both. Is there a way to customize this?
2) Is there also a way not to display column grand total but display only row grand total? and vice-versa?
Thank you in advance.
Regards,
Summer
Solved! Go to Solution.
HI @summer18,
#1, These parts are recognized as the same level and be control based on the grand total 'back color' options. You can't accurately control these parts. (BTW, conditional formatting does not work for total level)
#2, Yes, it is possible. You can enter to format panel to do custom with detailed total levels.
Create a matrix visual in Power BI - Power BI | Microsoft Docs
Regards,
Xiaoxin Sheng
HI @summer18,
#1, These parts are recognized as the same level and be control based on the grand total 'back color' options. You can't accurately control these parts. (BTW, conditional formatting does not work for total level)
#2, Yes, it is possible. You can enter to format panel to do custom with detailed total levels.
Create a matrix visual in Power BI - Power BI | Microsoft Docs
Regards,
Xiaoxin Sheng
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 |
---|---|
13 | |
2 | |
2 | |
1 | |
1 |