Dynamic filter for various slides in the same dashboard
I want to create a Cube based dashboard with multiple slides.
I want to add a country filter for all the slides but each slide it will show just the relevant countries for this specific slide - for example, the first slide will have UK, USA, Canada and Iraq while the second slide will have Japan, UK, Jordan and Iraq. I want the filter to dynamically show only the relevant countries for each slide.
How can I do it?
Easiest thing to do is simply add a new Country slicer to each slide, then set what elements appear in the slicer for each slide. As you add each slicer, you will be prompted that this slicer already exists and do you want to add a new one. click yes, then go to slicer settings for the slicer on each slide and choose what countries appear in the slicer through the Elements option.
Hope that helps!
How are the relevant countries for each slide determined? How can they be calculated dynamically? I.e. what is driving the list of relevant countries?
there may well be a way to do this, but you haven't given sufficient information for me to be able to deduce what the logic is.