Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Dear All,
Need help on this logic. I have a list of countries example
Santos, B Aires, Madrid, Yantai, Djbouti, Colombo, Dubai, Caucedo, Posorja. and year 2015, 2016, 2017 , 2018, 2019, 2020. most of these cities have data for all the years, but colombo, djibouti, yantai does not have any data after 2018. but when i use the cities in the slicer, i see all the cities even though they are not required after 2018. how can i restrict the data after that year?
Solved! Go to Solution.
@sure19
You can use the dates column in filter panel to the filter the City slicer. So the slicer only displays city names within the date range.
Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@sure19
You can use the dates column in filter panel to the filter the City slicer. So the slicer only displays city names within the date range.
Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@sure19 , Refer to this video, how a measure can help you control slicer value
https://www.youtube.com/watch?v=cyOquvfhzNM
This will only help when you have the year 2018 or above selected or passed to the page.
User | Count |
---|---|
126 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |