Forum Discussion
Helper IHow to remove (blank) from multilevel slicer
I'd like to not see the (blank) fields at all:
The table that feeds this slicer looks like this:
The slicer I used is the default slicer, where I dragged in 3 fields:
7 Replies
- TheoC
Community Champion
Hi LucMarv
Blanks arise due to gaps in the data model. A quick workaround is using the Filter Pane and selecting each field to remove the blank.
1. Click on the visual.
2. Go to the Filter Pane on the right.
3. Click on each of the fields you're using for the slicer.
4. Untick "BLANK".
Hope this helps.
Theo
LucMarvI just tried your suggested sollution, but it actually removed all the lines with at least one blank... the only remaining items in the slicer are those with all three elements filled:
All the others have disappeared... Any ideas how to fix this?
The gaps in my table are intentional.
- TheoC
LucMarv if there are gaps, there will be blanks unfortunately. Have you thought about creating a separate table with the specific categories and subcategories? Then you can create a relationship from the new table to the Fact table, and use the new table to Slice. The new table can be without blanks?
Otherwise, can you use the logic:
IF GroupingL3 is blank then fill the blank with Grouping L2
IF Grouping L2 is blank, then fill the blank with Grouping L1... and so on?
- LucMarv
There is a custom visual called 'hierachy slicer' which has the options to hide empty levels (GREAT), but this slicer does not support a dropdown version...
