Drillthrough - Detail Sheet Slicer is filtered

[rt2754]

Hello, please help.

DataSource: SSAS

On my Summary Sheet, I have drillthrough to a Detail Sheet.  Drillthrough works fine... it's able to filter the tables I have on Detail Sheet.  

Problem: Detail Sheet has Slicers... which further filters the tables on detail sheet.  But the slicer has all the dimension values.  I just need values that is applicable to what is being drilled through.

For example: I have a Summary Sheet that shows Monthly Sales.  Then I drillthrough to a specific Month and it gives me that month's details on Detail Sheet.  I have "Employee" slicer... this slicer shows all the employees even though that employee has no sales that month being drilled through.

How will the slicer on the Detail Sheet be dynamically changing based on what is drilled through from the Summary Sheet?

Thank you very much! 🙂

[parry2k]

@rt2754 in a way it is possible to set filter direction to "both" but it has performance implications on larger dataset. You can test it in your environment and see if it meet your needs.

[v-frfei-msft · Accepted solution]

Hi @rt2754 ,

How will the slicer on the Detail Sheet be dynamically changing based on what is drilled through from the Summary Sheet?

---

Based on my test, it is not possible to meet your requirement currently.You can come up a new idea about that and add your comments there to improve Power BI and make this feature coming sooner.

https://ideas.powerbi.com/forums/265200-power-bi-ideas