Ability to remove drill through filter using slicer

[dhirajd]

I have a report where I am using a DAX measure to calculate SUM(Sales) for consumer segment in a card visual.

Here's the DAX measure.

SalesForConsumer =

CALCULATE(SUM(Orders[Sales]),Orders[Segment] = "Consumer")

I have a drill through filter which will show the sales in each region for consumer in a table form.

This is how the table looks after drilling through the SalesForConsumer Card.

I need the slicer in the drill through page to show slicers for other segements as well and not just consumers. Drill through should filter the report as intended but I want the slicer to be selected for 'consumer' and still show the other slicer options.

Something like this:

Currently it is not possible without actually removing the drill through filter for visualizations pane.

Here is the PBIX file: https://bit.ly/3CGzCnO

Please help.

[v-yueyunzh-msft · Accepted solution]

Hi , @dhirajd 

I download your pbix file and test it in my side , When you Drill through to the second report page, the filter carried is the filter configured in "Filter on this visual" of your card visual.

If Dril goes to the second page, all segment="Customer" data will be filtered by default, which is by design. and cannot be modified.
So you may nor realize by the drill feature.

If you want to select a certain value of the slicer by default, you may need one more step, which is to select a certain value of the slicer in page1 first.

Then you can configure the two slicer in a group as a sync slicer.And then you can create a button and configure its' action to the Page navigation.

For more informtion, you can refer to :
Enable the Sync Slicers feature in Power BI visuals - Power BI | Microsoft Learn

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

Best Regards,

Aniya Zhang

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

[some_bih]

Hi @dhirajd did you try simple measure like Sales= SUM(Orders[Sales])? Then you slicer and other filters. Hope this  help