Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
95 | |
80 | |
67 | |
62 |
User | Count |
---|---|
147 | |
109 | |
107 | |
85 | |
63 |