Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
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
User | Count |
---|---|
140 | |
113 | |
104 | |
76 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |