selective names

[sure19]

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?

[V-pazhen-msft · Accepted 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.

[amitchandak]

@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.