Forum Discussion

dhirajd's avatar
dhirajd
Regular Visitor
3 years ago
Solved

Ability to remove drill through filter using slicer

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[Segme...
Need Help
Tips and Tricks
  • v-yueyunzh-msft's avatar
    v-yueyunzh-msft
    3 years ago

    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

     

v-yueyunzh-msft's avatar
v-yueyunzh-msft
Icon for Community Support rankCommunity Support
3 years ago

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