Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi,
We have a page enabled with Drill down feauterd on District wise Stacked Graph with 3 values. The data get filtered based on the Reporting Month selection defied through the Slicer.
Screenshot#1
District Wise Counting
We can drill down to the next level by selecting any of the above displaying chart and its getting filter and showing the correct data for the selected done (district name), but we are not getting the filter applied to the other field value (Reporting Month) defined in the Card visual.
Screenshot#2
I also tried to enable/disable the option "Keep all filters" but still not able to get the same Reporting Month Value to be filtered.
So, do we have any further option to get the same Reporting Month value to be filtered in the next page (screenshot#2)
Thanks in advance for your support on this.
With Best,
Sahu
Hi @gurudayalsahu,
In addition to checking the Keep all filter option, please check 'Cross-report' options.
You need choose the 'Cross-report' in options and settings.
If you still have some question, please don't hesitate to let me known.
Best Regards,
Link
Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!
Hi Link,
Thanks for going through it and providing the further details.
After enabling both of the above options (Cross Report and Drill Down ),
In the next page Drill down page, it is filtering the data for the selected one (1 value out of 3). For example, when i am selecting "Drill Down" option in the below marked stacked bar chart of Distrct named "Ayodhya" that has got 3 diffirent results/values:
It is taking me successfully to the next page having the correct Month display as it was selected, but the stacked bar showing the details only for the single value, while other 2 values are not visible.
As per the requirment, it should show below details in the stacked bard chart along with Month name card as "Aug 2020" instead of "Apr 2020" :
Hope, I am sharing all the requried details for the further investigation.
Please also let me know in case any other details required.
Thanks once again !
With regards,
Gurudayal Sahu
Hi @gurudayalsahu,
According to your description, the issue you are experiencing is the both:
1. After drilling down, some data miss.
2. After drilling down, selection of slicer was affected.
Please correct me if I have misunderstood.
In addition, could you provide your data structure?
I will try to create a simple demo to reproduce your issue.
Best Regards,
Link
Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
146 | |
75 | |
64 | |
52 | |
47 |
User | Count |
---|---|
218 | |
88 | |
73 | |
64 | |
60 |