Forum Discussion

jleo25's avatar
jleo25
New Member
8 years ago
Solved

Make Totals on a Matrix Red if Negative

In my matrix I have all positive numbers black and all negative numbers red except for the totals. I have months as my column and departments as my lines, I have totals for both month and department....
  • Mond's avatar
    Mond
    8 years ago

    Hi,

     

    We don't have conditional format on Totals.

    Create another table of same structure with dept and final amount column next to the existing matrix.

    Format Dept column to be hidden (may be column width to "2 points") and do conditional format on Final Amount column.

Phil_Seamark's avatar
Phil_Seamark
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi jleo25

 

Yes you can use conditional formatting.  Click the down arrow of the field you would like to apply the conditional formatting to.

 

 

 

Then choose conditional formatting from the menu and then font colour scales

 

 

finally configure the conditional formatting dialog for your field as follows

 

 

Which should give you

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hey jleo25

     

    I don't think it's possible to conditionally format the Total row. Hopefully I'm wrong.

     

    Parker

    • Phil_Seamark's avatar
      Phil_Seamark
      Icon for Microsoft Employee rankMicrosoft Employee
      8 years ago

      I managed to get something working using a Table visual

       

      The total line isn't bold, but will switch from red to black depending on totals.

       

      I have attached a PBIX file.

       

       (edit - I have slightly updated the PBIX file to make it tidier)

  • jleo25's avatar
    jleo25
    New Member
    8 years ago

    That is how I got all of the other numbers to look how I wanted but it did not change the totals. Maybe I am missing something? I attached a pic of what I am working with, I have everything looking how I want except the totals.

     

     

     

     

     

    • Mond's avatar
      Mond
      Icon for Helper III rankHelper III
      8 years ago

      Hi,

       

      We don't have conditional format on Totals.

      Create another table of same structure with dept and final amount column next to the existing matrix.

      Format Dept column to be hidden (may be column width to "2 points") and do conditional format on Final Amount column.

      • jleo25's avatar
        jleo25
        New Member
        8 years ago

        Thank you, that is what I was just trying to figure out after reading your 1st post. Thanks again