The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hello,
I suspect this has a straightforward answer but I'm going round in circles! Hopefully someone can help.
I have a matrix table and am using row sub-totals.
I only want one of the rows to have a sub-total and am getting this to show as desired.
The issue I have is using a background colour to show the sub-total row.
If I opt to have a background colour, it hightlights all the columns as well, which I don't want.
I only want the sub-total row to be highlighted in a different colour; how can I achieve this please?
For example:
Turning on the sub-total row for the column without applying to labels shows this (ignore grey boxes, used to hide personal data):
But I want the green background to extend to show from the word "Total". If I select "Apply to labels", i get this:
I don't want the entire columns to be green, only the sub-total row.
How can I achieve this please?
Solved! Go to Solution.
Hi @AliPoTD
You can write a measure to conditionally format just the subtotals. Example:
conditional formatting color =
IF (
NOT ( inscope ( table[column in the lowest level of the hierarchy] ) ),
"color"
)
Replace color with RGB, RGBA, HEX or basic colors like green or red. Choose field value from the conditional formatting option and select this measure.
Please note that conditional formatting applies to values section of the matrix only and does not extend to the row or column categories. Othere than this, there is no other way to color just the subtotals.
Hi @AliPoTD
You can write a measure to conditionally format just the subtotals. Example:
conditional formatting color =
IF (
NOT ( inscope ( table[column in the lowest level of the hierarchy] ) ),
"color"
)
Replace color with RGB, RGBA, HEX or basic colors like green or red. Choose field value from the conditional formatting option and select this measure.
Please note that conditional formatting applies to values section of the matrix only and does not extend to the row or column categories. Othere than this, there is no other way to color just the subtotals.
Many thanks for getting back to me. Understood. Unfortunately my issue does not relate to the Value but to the Row data, so I can't use conditional formatting.
Ah well, I've learned something new at least!
Thanks for your help.
User | Count |
---|---|
87 | |
84 | |
36 | |
35 | |
30 |
User | Count |
---|---|
95 | |
74 | |
67 | |
52 | |
51 |