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 Everyone,
I have an issue with Hierarchy slicer visual. I used the visual to filter data based on Main Category and sub-category fields. The Main Category is on one table but the sub-categories are in defferent tables. The issue is when I draged- droped the sub-categories to the slicer, I have to brows many blanks levels to reach to child level. The below image illustrates the issue. Please advice thank you 🙂
Please consider voting to my idea to add this option to the Matrix visual:
In the Format section of the Visualizations pane, you may enter "Empty Leaves" in the "Search" textbox.
I used the "empty leaves" option but it didn't work well because, if the parent level is blank, all the next levels are removed, even if there are data in them. I simply need to hide blanks only when there are no data - i.e. if the parent level is blank and there are data in the next level, only the parent level should be removed.
Thank you
The parent shouldn't be blank in the first place, should it?
I'd advise you to:
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 |
---|---|
97 | |
97 | |
81 | |
77 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |