cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
saivenkat Member
Member

Drill to a different report

Hi All,

I have done  many drill down reports using SSRS. Is that possible in powerbi? I have two reports , the first report is a table that shows SALES by month , another report is the same data but showing sales by week (Graph Report). What i am looking for is in the first report summary report (sales by month) when  i click either on the sales column or the month column , the detailed sales by week report is supposed to pop up. For example if i click on April it should take me to the detailed april report by week.

In SSRS i used linked report and passed the parameters from the first report to the second. Please advice .

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support Team
Community Support Team

Re: Drill to a different report

hi, @saivenkat 

You could get it by Use cross-report drillthrough in Power BI Desktop.

Here is the document for you refer to:

https://docs.microsoft.com/en-us/power-bi/desktop-cross-report-drill-through

 

Best Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
Highlighted
Community Support Team
Community Support Team

Re: Drill to a different report

hi, @saivenkat 

You could get it by Use cross-report drillthrough in Power BI Desktop.

Here is the document for you refer to:

https://docs.microsoft.com/en-us/power-bi/desktop-cross-report-drill-through

 

Best Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
saivenkat Member
Member

Re: Drill to a different report

Thanks for the help!

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 259 members 2,945 guests
Please welcome our newest community members: