Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
109 | |
89 | |
76 | |
66 |
User | Count |
---|---|
126 | |
112 | |
99 | |
82 | |
73 |