Forum Discussion
Helper IIIDisplay related records
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
5 Replies
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
JorgeAbiadHello Anonymous ,
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
- v-luwang-msft
Community Support
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 RegardsLucien
- v-luwang-msft
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
