Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Optimal solution for below issue

I have a report which looks something like this:

I want to turn the top 5 KPIs into bookmark such that clicking on each KPI would filter down below four table and charts. For eg. If I click on Forecast error KPI, it would filter all below charts on a condition (forecast error> 20). Similarly clicking on rest of the KPIs should have required filtering on below 4 visuals.

What is the optimal way to implement this solution ? I can create 5 of each below visuals and use bookmarks to traverse through them whenever a kpi is selected. Is there a better way to implement this ?

 

Need Help

3 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    5 years ago

    Create buttons for your bookmarks. Position the buttons on top of the KPIs.  Make the button text and background transparent.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Thank you for replying.

      This I am already doing. My question is if there is a way through DAX to implement the filters once any KPI is selected. My last resort would be to create 5 copies of each visual and filter it based on the KPIs

  • lbendlin's avatar
    lbendlin
    Super User
    5 years ago

    "My question is if there is a way through DAX to implement the filters once any KPI is selected"

     

    That question is ambiguous.  what does "implement filters"  mean?  Yes, you can use DAX measures to recalculate based on filter selections. No, you cannot change slicer selections through DAX.