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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
nmaram4373
New Member

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 REPLY 1
Ritaf1983
Super User
Super User

Hi @nmaram4373 
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...

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

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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