Forum Discussion
customising PowerBI Marrix Visual for Hyperlink ( Transpose Table )
Hi rakikumarpatra ,
I recommend drill through.
On page 1, you have PBI matirx table and On page 2 , add tableA via table visual and [Run Name], [Testcase] in Drill through.
Go back page 1 select a cell you want to see more details right click , drill through.
Then , the page 2 will filter the table depend on the cell you right click. Rsult:
Pbix in the end you can refer.Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks , for this solution , but in our case Transpose Table has 11000 Column could it possible to filter only column using this drill through menu ?
Hi rakikumarpatra ,
Theoretically, drill through can be filtered by many columns. However, in practice it only passes the values of all the columns in that row for filtering.
As you can see, I put [Run Name] and [Testcase] in the drill through list, and on the target page, I get the whole row where [Run name] = 'run name 1' and [Testcase] = 'testcase2' . In another word, all the rows match the condition will come out the page2. More fields(columns) in drill throgh list, more precision.
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.