Forum Discussion
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....
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.
Hey jleo25
I don't think it's possible to conditionally format the Total row. Hopefully I'm wrong.
Parker
Phil_Seamark
Microsoft Employee
Microsoft EmployeeI 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)