Forum Discussion

LucMarv's avatar
LucMarv
Icon for Helper I rankHelper I
4 years ago

How 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: ...
Need Help
TheoC's avatar
TheoC
Icon for Community Champion rankCommunity Champion
4 years ago

Hi LucMarv 

 

Apologies, I'm referring to a Dim table that is structured in such a way that blanks don't exist and only the attributes of the specific groups are captured.  If you have to have so many blanks, then just break it down further into separate tables that have a one to many off one another back to the fact table.

 

So, you'd have:

  • Level 1 table
  • Level 2 table that has columns being Level 1, Level 2 but excludes any Level 2 blanks.
  • Level 3 table that has columns being Level 2 and Level 3, but excludes Level 3 blanks.

This way, your Slicer will be Level 1 category from table Level 1.  Level 2 category from table Level 2. Then Level 3 category from table Level 3.

 

Hope that makes sense?

Theo

 

DataStitcher's avatar
DataStitcher
Regular Visitor
2 years ago

I have tried this approach of the Fact and Dim table for a similar issue and found out it does not work. It will result in the exact same outcome with blanks in the slicer although the Dim tables do not contain any empty results. Removing the blanks through filtering will only show the groups with all columns filled.

In the end it seems like the best option is to go with the custom 'hierarchy slicer' mentioned by LucMarv. Although this custom visual lacks dropdown functionality.