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.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
1 year ago

Put the Date column of your calendar dimension in the X axis and let the visual do the rest.