Forum Discussion
Filtering through hierarchy excluding blank values.
Hello - I have a hierarchial data model and inside each, there could be empty values. I want to add slicer that should show the folders/levels but not the blank values under them. I have tried ex...
Hi SM321 ,
According to my knowledge, you may not be able to achieve this directly with a slicer.
If you put these data into the same slicer, the whole hierarchy will be filtered out as long as this hierarchy contains the Blank value you want to filter out.
You can put each level of data into a different slicer:
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks Jianbo for responding! Yes, I figured that out and different slicers wouldn't serve my purpose, because it would occupy much real estate. I tried using a custom slicer, that has worked for my situation. Thank you for responding!