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

Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.

Reply
Anonymous
Not applicable

Dynamic stack chart based on slicer selection

Hi All, 

Any help on this is much appreciated - May be this is already covered by someone but I was unable to find it hence requesting here.

 

In my Power_BI Dashboard

 

I have a Stack chart based on number of reported incidents on daily basis.

A Slicer for each month for user to select single or multiple months to see number of reported incidents for selected months

Based on user selection in slicer 

 

If User Selects ONLY One month

Then

Stack chart should show DAY WISE VIEW for the selected month

 

If User Selects multiple months 

Then

Stack chart should change to MONTHLY VIEW with total incidents for all months that are selected in slicer

 

 

  

1 ACCEPTED SOLUTION
Ritaf1983
Super User
Super User

Hi @Anonymous 
Dynamic dates axis achievable with field parameters,
Please refer to my solution in the linked discussion  ( it includes PBIX with the example)

https://community.fabric.microsoft.com/t5/Desktop/Dynamically-change-dimension-based-on-Slicer-value/m-p/3289067

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

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

View solution in original post

1 REPLY 1
Ritaf1983
Super User
Super User

Hi @Anonymous 
Dynamic dates axis achievable with field parameters,
Please refer to my solution in the linked discussion  ( it includes PBIX with the example)

https://community.fabric.microsoft.com/t5/Desktop/Dynamically-change-dimension-based-on-Slicer-value/m-p/3289067

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

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.