Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Row sub-totals are being displayed twice in my matrix. One on top and other on the bottom. If I try to disable the row subtotals toggel, then it's disabling them both. I'm only able to toggle the them to bottom/top but unable to remove the extra one.
When toggled to the bottom, this is how they look. I can't choose to change the font color to white to ignore the extra subtotal being displayed as I'm using conditional formatting to highlight some score discrepancies and applied the rule to subtotals as well, which will highlight as shown below. Please suggest
Solved! Go to Solution.
@sk30 Create a measure for your conditional formatting that takes into account whether it is in the total row or not and returns the correct color code appropriately.
@Greg_Deckler Thanks, for that. I did try that initially but now since I'm using conditional formatting to highlight the background color, the hidden (white fonted subtotal) is also being highlighted as attached in the above pic
@sk30 Create a measure for your conditional formatting that takes into account whether it is in the total row or not and returns the correct color code appropriately.
@sk30 Try switching your Row grand total to have white text.
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
84 | |
66 |