Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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 |
---|---|
98 | |
90 | |
84 | |
70 | |
67 |
User | Count |
---|---|
113 | |
104 | |
101 | |
73 | |
65 |