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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

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

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!