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.
Hello,
For some reason, when using the Power BI Matrix visual, I experience duplicate 'ghost' subtotals when the following settings are true:
1) Subtotals are turned on
2) 1 or more levels of subtotals are 'skipped' inbetween levels that are turned on
3) The matrix is sorted by one of 'values' columns on the right-hand side of the matrix
When the Value column is not sorted or is sorted by one of the row columns on the left, the second 'ghost total' does not appear.
Additionally, I have confirmed that it does not matter if the subtotal is set to 'top' or 'bottom'.
Lastly, it does not appear to be an issue to be resolved with DAX, as it does not matter if I use an explicit 'SUMX (SUMMARIZE(....' measure, a simple CALCULATE measure, or simply drop the 'NetAmount' field directly on the matrix and allow Power BI to SUM it.
If this is a bug, it would be great if it could be addressed - thanks!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.