Slicers from top level to bottom level RRS feed

  • Question

  • Hello. I have three slicers. Going from a top level to lower levels. THey work fine, but when I slice by one of the lowest levels and then change the first level without clearing the filter it returns nothing and/or NAs. Is there any way that I can the slicers to adjust based on the connections? 
    Sunday, February 5, 2017 10:11 AM


  • Unfortunately not. If you select combinations that don't exist you will get this behaviour. There is no way to turn it off. You may be able to write some vba, but I suggest training users not to select invalid colminations would be a better approach.

    Self Service BI Expert using Power Pivot http://exceleratorbi.com.au

    Sunday, February 5, 2017 11:17 AM