Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don'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.

Reply
gurudayalsahu
Frequent Visitor

Issue in stacked chart with more than 1 values during drill down to next page

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 CountingDistrict 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

 

gurudayalsahu_3-1625232173607.pngI 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

 

 

3 REPLIES 3
v-xulin-mstf
Community Support
Community Support

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.

vxulinmstf_0-1625470445882.png

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 ),

gurudayalsahu_3-1625472607105.png

 

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:

 

gurudayalsahu_0-1625471953813.png

 

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.

 

gurudayalsahu_1-1625472222439.png

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" :

gurudayalsahu_2-1625472383769.png

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!

 

 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.