Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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
Hi @rutujar2 ,
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
Hi @v-luwang-msft ,
Can drill-down selection get passed through the slicers on any given page?
Regards,
Rutuja
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!