Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Drill down selection not changing the slicer

Hi All,

 

I have a report created where I have a clustered column chart with a drill down and a few slicers. When I am drilling down or up into the chart, the slicer values are not changing as per the chart drill down or up. Can somebody please help?

 

For example, if I have a column chart showing sales every quarter and if I drill down, then the month-wise sales is displayed. Additionally, I also have a slicer for quarter to select. When I drill down to Q2 in the chart, my slicer should change the options to show only Q2 selected.

 

Regards,

Rutuja

Drill Down and Up
Slicer

2 Replies

  • v-luwang-msft's avatar
    v-luwang-msft
    Community Support
    3 years ago

    Hi Anonymous ,

    Only the field that is in the drillthrough filters well gets passed through to the drillthrough report page. No other contextual information is passed.

    So, the slicer selection in the page will not be passed.

     

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

     

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

     

    Best Regards,
    Lucien

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hi v-luwang-msft ,

       

      Can drill-down selection get passed through the slicers on any given page?

       

      Regards,

      Rutuja