Cascading to a Table Visual From a Hyperlink in Matrix Visual

[RKM]

(Please and please read the description before simply marking some reply as 'answered' (despite it is really not an answer), as I am recently seeing this too often here in PBI forum. Kindly don't do that and allow more people to respond. I PROMISE - if some answer is really resolving the question, I'll mark it answer... I promise!!! )

So, I need some help from the experts. I already have a PBI dashboard where I have a Matrix like below... Here we are seeing Quarterly Possessions For each delaer at Product Level detail. This is very very simple....

Now the Need is that the Name column above - should have a Hyperlink for each of the records and on-click of that HyperLink, we want to see More details about that ProductName.... i.e. One Cascading Parameter Report Visual Kind of (If nothing is clicked then show nothing). 

The real twist is that this Detail of Each Product Name level, is coming from a Stored Procedure...

i.e When you click 'BK1' then that will be the parameter of SP   { Exec dbo.utvf_GetSpecificProductAttributes @ProductName}

~ Also note that, this SP will return different number and list of Columns depending on which Product Name we are passing. For example, for BK1 - it is returning 6 columns where as for Car1 it is returning 8 columns. Also note the differences of returned column names.

My Question is: 

(a) This kind of Cascading report - is it possible in Power BI on same dashboard Or

(b) Should it be like, the first matrix will remain in Power BI and upon clicking the Product Name link - it should call a SSRS or paginated report with Param etc,?

Are there any sample PBI you can redirect me to please, where we are calling SP based on Hyperlink and passing param and SP returning dynamic number of columns.

[v-yinliw-msft · Accepted solution]

Hi @RKM ,

When to use the paginated reports, the Interactivity features: Interactive features include toggling visibility (to drill down and drill up), links, interactive sorting, and tooltips. You can also add links that drillthrough to Power BI reports, or other Power BI paginated reports. Links can even jump to another location within the same report.

You can pin the visual to the dashboard.

SSRS is a tool to build the paginated report and the parameter with the Power BI Report Server. You should call paginated report.

For more information, you can refer these documentations below:

When to use paginated reports in Power BI - Power BI | Microsoft Learn

Pin paginated report items to Power BI dashboards - Reporting Services - SQL Server Reporting Servic...

Hope these help you.

Best Regards,

Community Support Team _Yinliw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[RKM]

Indeed very very helpful. Specially links that you shared. Thank you for your time and effort, really appreciate that.