Forum Discussion
Dynamic Date Axis based Slicer Select All
I want to have a dynamic date X Axis for when my slicer has "All" selected vs a specific Year.
In my case, when "All" is selected in the Year slicer, I would like to show all the trending years and when a specific year is selected I would like to show the trending Months for that year.
Anonymous Columns don't update with slicers, so there's not a simple way to acheive this. You could vote for an idea or post your own one here: https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=a9065620-db39-47ac-aa26-af3b35051b36
Otherwise, use bookmarks and create two visuals - one by month and one by year. Then add a bookmark navigator to let users choose which level they want to view (can't be automatic based on the slicer unfortunately).
1 Reply
Anonymous Columns don't update with slicers, so there's not a simple way to acheive this. You could vote for an idea or post your own one here: https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=a9065620-db39-47ac-aa26-af3b35051b36
Otherwise, use bookmarks and create two visuals - one by month and one by year. Then add a bookmark navigator to let users choose which level they want to view (can't be automatic based on the slicer unfortunately).