Forum Discussion

StevesHelp's avatar
StevesHelp
Icon for Helper I rankHelper I
8 years ago

Slicers not limited to data

Usually when I have table and a look up table with date to use as a slicer, the look up table will be limited to my data.

 

Example:

 

My data is 2016-2018. Even though my look up table is 2010-2018, when I make the 'Year' slicer, it will only show 2016, 2017, and 2018 as options.

 

This time it shows all years.

 

All my relationships are normal, no idea why this is happening for all my slicers.

 

None of them are limited to my data.

 

Any advice?

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    StevesHelp,

    my first guess without looking at the dataset/data model is you used Year from your lookup table as your slicer, thats why it listed all the year from 2010 to 2018