Dynamic default selection for Multi-Select, Date Hierarchy Slicers
Hi there! I've got a report which shows a year-on-year comparison, based on a user customised date period e.g. a user could select Q4 2023 and Q1 2024 which would compare to Q4 2022 and Q1 2023.
In order to achieve this level of user customisation, we have a date hierarchy slicer which is also multi-select, not single select, otherwise we would not be able to compare the date ranges above. It also means that deselecting all dates (effectively 'select all') causes the visuals showing the year-on-year analysis to not make a lot of sense. This is highly likely to confuse users, so to try and avoid this, instead of allowing the report to default load on a date hierarchy slicer with no selection, we selected the 'current year' before publishing the report (report was showing 2024 at the time of writing this), so this 'current year' slicer selection is the default view.
Now we are in 2025, we can republish the report with an updated 'current year' selection of 2025, but this manual step (which may also exist in many other reports) is a bit onerous and feels like it shouldn't be necessary on a dynamic report. I can't see a way in the filter or formatting panes to include some logic to dynamically keep the date slicer default selection in line with the actual year we're in. So what would be great, is some functionality, maybe in the Format > Slicer Settings pane, to instruct a dynamic default selection on date hierarchy, multi-select slicers (i.e. 'current year', although there may be other slicers where a similar approach could benefit).
N.B. This is not a 'bookmark' - creating multiple bookmarks still wouldn't allow for a single, consistently applied default view. The idea here is to have a dynamic default view so we don't have to republish reports at the start of every year.
1 Comment
- fbcideas_migusrNew MemberStatus added:New
Recent ideas
Allow Managed Private Endpoint to be disabled/enabled per notebook
Could notebooks have an option to use or not use the workspace's Managed Private Endpoint (MPE)? MPE can significantly increase notebook startup time, even for notebooks that don't need private conn...frithjof_v22 hours agoCommunity ChampionNew24Views1like0CommentsMatrix: column totals as a bar chart docked to the edge
What's missing Data bars already work on the Total row and column through conditional formatting, so row totals can be read as length. Column totals cannot: they render as a horizontal bar inside a ...Sayurivalente1 day agoRegular VisitorNew80Views6likes1Comment