Forum Discussion

parthrvyas11's avatar
parthrvyas11
New Member
1 year ago
Solved

Automatically Change Stacked Column Chart from Years to Months Based on Slicer Selection

Hi all, sorry for the long title. I have three stacked column charts in my dashboard and I want it to display yearly data by default but when I select a certain time frame (say 1/1/24 to 12/31/24) I ...
Need Help
  • v-sathmakuri's avatar
    v-sathmakuri
    1 year ago

    Hi parthrvyas11 ,

     

    Thank you for reaching out to Microsoft Fabric Community.

    Thank you lbendlin for prompt response.

     

    1.Create Two Charts

    • One with Year on the axis
    • One with Month/Year Month on the axis

    2. Use the Selection + Bookmarks Pane to toggle visibility automatically.

     

    If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

     

    Thanks & Regards,

    Rekha,

    CustomerSupportTeam.

v-sathmakuri's avatar
v-sathmakuri
Icon for Community Support rankCommunity Support
1 year ago

Hi parthrvyas11 ,

 

Thank you for reaching out to Microsoft Fabric Community.

Thank you lbendlin for prompt response.

 

1.Create Two Charts

  • One with Year on the axis
  • One with Month/Year Month on the axis

2. Use the Selection + Bookmarks Pane to toggle visibility automatically.

 

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

 

Thanks & Regards,

Rekha,

CustomerSupportTeam.