Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
StevesHelp
Helper I
Helper I

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?

1 REPLY 1
Anonymous
Not applicable

@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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.