Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello PBI Experts,
In my matrix visual, I have included the KPI status in red:
Is it possible to display the records comprising these red status in a table considering the filters applied?
Regards,
JorgeAbiad
Hi @JorgeAbiad ,
Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.
Best Regards
Lucien
Hi @JorgeAbiad ,
You could achieve this through Page Navigation and Button.
Click the button then it will take it to “List of Products” page and it will show the same numbers.
to learn more details ,refer:
https://www.linkedin.com/pulse/clickable-kpis-cards-power-bi-drill-through-from-hariharan-rajendran
https://prathy.com/2017/07/powerbiworkaroundsclickablecard/
Did I answer your question? Mark my post as a solution!
Best Regards
Lucien
Hello @JorgeAbiad
Simply create a table with all your records and then put a filter on this visual to only keep records where %Response Status = red.
Please accept it as a solution if it answers your need
Hello @AntoineTRICHET ,
Thanks for the reply. What I want to achieve is when I click on the Red circle inside a cell, then I will be redirected to another report showing all the records in a table visual. If possible, can it be also shown in a popup window.
Thanks,
JorgeAbiad
Hi @JorgeAbiad
The functionnality you need is drillthrough. Plenty of video explain how to do it (on Youtube), such as this one : https://www.youtube.com/watch?v=WdBeJ8j98ME. You need to create a tab with the records table details you want and "activate" the drillthrough between the two visuals.
I hope it will help you.
Please accept it as a solution if it solved your issue
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |