Forum Discussion

JorgeAbiad's avatar
JorgeAbiad
Icon for Helper III rankHelper III
5 years ago

Display 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?  ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

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

JorgeAbiad's avatar
JorgeAbiad
Icon for Helper III rankHelper III
5 years ago

Hello 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

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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