Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Hi!
I have table like this:
Try to make hierarchy view by HierarchySlicer:
And when I tried to remove (blank) items:
Now it looks like this:
Where is my Ancle node? How can I solve it?
Hi @stambovcev,
For Ancle node, the value is blank in Level3. So it has been removed after filter. As I tested, the result is the same, all the rows where the level3 is blank will be removed. We can not set custom option. You can comment it in the Costomer Reviewers zone.
Best Regards,
Angelia
User | Count |
---|---|
98 | |
76 | |
74 | |
49 | |
26 |