The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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 ?
"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.
Create buttons for your bookmarks. Position the buttons on top of the KPIs. Make the button text and background transparent.
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
User | Count |
---|---|
63 | |
56 | |
54 | |
51 | |
31 |
User | Count |
---|---|
180 | |
88 | |
70 | |
46 | |
43 |