Solved: Drill through report not working as expected

Anonymous · ‎08-11-2020

Hi All,

I have created a drill through report and it is not working as expected. I have a main report summary level and slicers. When i select 2020 and then click on the drill through to goto the detailed report it is showing all the years and not just 2020. Please advice.

Thanks

v-yingjl · ‎08-11-2020

Hi @Anonymous ,

Try to enable 'keep on filters' and change the filter type as 'Used as category'

Refer:

Best Regards,
Yingjie Li

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

View solution in original post

v-yingjl · ‎08-11-2020

Hi @Anonymous ,

Try to enable 'keep on filters' and change the filter type as 'Used as category'

Refer:

Best Regards,
Yingjie Li

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

Anonymous · ‎08-12-2020

Thank you , it is not clear as to where i need to make these changes. In the main report or the report that i need to drill to? Also i do not see the options of summarized and used as category.

parry2k · ‎08-12-2020

@Anonymous it will on drill thru page, and summary/category will show if the column is a number, it is not critical for you,, just use category.

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

amitchandak · ‎08-11-2020

@Anonymous , How you added year as part keep filters

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-drillthrough

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Anonymous · ‎08-11-2020

Did not understand your question.

ibarrau · ‎08-11-2020

Hi. The only thing I can think is the keep filters. Please be sure that you have activated the keep filters option in the page in the middle between the cross-report and drillthrough field.

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-cross-report-drill-through#use-cros...

Hope that helps,

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

Happy to help!

LaDataWeb Blog