Drill through on blank column showing Values in Slicers in Target Page

[Optimusprime_25]

Hello Team,

I have a report with Overview and Details as pages. I have enabled drill through in Overview page, when user clicks drill through on Product column then details with that respective product should be displayed in Details page.

We are having standard slicers in both Overview and Details pages. When user clicks drill through on any blank value then in Details page matrix visual is showing blank data which is expected but Now the main issue is we are able to see the data in Slicers. Ideally Slicers should be blank.

Could you please help us in resolving this issue.

Thanks.

[Anonymous · Accepted solution]

Hi @Optimusprime_25 ,

Please ensure that the slicers on the Details page are configured to show data relevant to the selection made on the Overview page. They should be connected to the same fields that are being used for the drill-through.
If the content in the slicer has nothing to do with the field used for the drilldown, it will not be affected by the drilldown.

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

[lbendlin]

 but Now the main issue is we are able to see the data in Slicers. Ideally Slicers should be blank.

Not clear to me what your issue is. Can you show an example?