Forum Discussion
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. Is there any way to format these just like the rest of the matrix? I just want positive to be black and negative to be red.
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.
8 Replies
- Phil_Seamark
Microsoft Employee
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
Hey jleo25
I don't think it's possible to conditionally format the Total row. Hopefully I'm wrong.
Parker
- Phil_Seamark
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)
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.
MondHelper III
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.
- Mond
We don't have conditional formatting for Totals, but I can suggest to use high level table / matrix for the summation and make conditional format on the values.
Hope this help !
I had this same question then figured it out:
When you apply conditional formatting to the values themselves, you can select apply to Values and Totals in the UI
