The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
97 | |
80 | |
62 | |
57 |
User | Count |
---|---|
262 | |
120 | |
115 | |
83 | |
70 |