Forum Discussion
Helper IIIformatting issue on Matrix chart (grand totals)
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
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
1 Reply
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