0

Dynamic filter for various slides in the same dashboard

Hi,

 

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?

3 replies

null
    • Senior Director of Product
    • Ian_Macdonald
    • 6 mths ago
    • Reported - view

    Hi dgf,

    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!

    Ian

      • dgf
      • 6 mths ago
      • Reported - view

      Ian Macdonald Thanks!
      I have experienced with few other dashboarding tools and it was a very helpful feature I used all the time. Could you consider developing it?

    • Senior Director of Product
    • Ian_Macdonald
    • 6 mths ago
    • Reported - view

    Hi dgf,

    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.

    Ian

Content aside

  • Status Answered
  • 6 mths agoLast active
  • 3Replies
  • 31Views
  • 2 Following