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.
My data set it is using a hiarchal structure that does not require a value in each level of the hiarchy. This causes several subtotal line to appear as blank lines in the matrix and add extra subtotals that arn't needed. Is there any way to hide subtotal rows with a blank description.
Here is a sample of the output.
Not quite, I'm tying to hide the following lines outlined in red.
Hi @Anonymous,
By my tests, if you set the value like below in visual level filter then you could achieve your desired output.
Best Regards,
Cherry
Thank you for your reply Cherry, This solution doesn't really work for my issue.
In my data set I don't have any lines with 0 values, but I do have lines with missing values in L3, L4, and L5 header. Here is a sample of what the data looks like:
The problem comes in because not ever line has a value for L3, L4, L5, but some do. Since I'm grouping the rows by that field it will used the blank value in there and treat it as if there was a value.
Hi @Anonymous,
If I understand your requirement correctly that you want to hide the rows highlight in red?
If it is, you could use the solution I mentioned for the first reply, may be you could try is not blank.
Best Regards,
Cherry
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 |
---|---|
106 | |
97 | |
80 | |
67 | |
63 |
User | Count |
---|---|
147 | |
110 | |
108 | |
85 | |
64 |