Forum Discussion

summer18's avatar
summer18
Icon for Helper III rankHelper III
5 years ago
Solved

formatting 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, th...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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