drillthrough from summary table row help

[askme1217]

i have Orders summary table like  year, category, total_sales. I want to create a drillthrough report from the total sales number row  and see all relevant order details page.  total_sales value is coming from a measure.  if right click and drillthrugh from that row, all filters are not passed and it is showing all orders. 

1. i dont want to right click and drillthrough

2. i want to click on row value be able to drillthorugh to details page.  

is it possible to do?

[maruthisp · Accepted solution]

Hi askme1217,

As per my knowledge, use a button with drill through action. Can you try this approach?

If this reply helped solve your problem, please consider clicking "Accept as Solution" so others can benefit too. And if you found it useful, a quick "Kudos" is always appreciated, thanks! 

Best Regards, 

Maruthi 

LinkedIn - http://www.linkedin.com/in/maruthi-siva-prasad/ 

X            -  Maruthi Siva Prasad - (@MaruthiSP) / X

[v-aatheeque]

Hi @askme1217 ,

Just checking in @maruthisp has shared a response to your query regarding to create a drillthrough report from the total sales number row  and see all relevant order details page.

If the provided solution helped, please consider marking it as Accepted Answer, as it may also benefit others facing a similar challenge. If you're still looking for more clarity or facing issues, feel free to share more details we’re happy to assist further.

Thank you for being part of the Microsoft Fabric Community!