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
Justification Prompts When Downgrading or Removing Sensitivity Labels in Power BI Desktop
Description Currently, organizations can configure Microsoft Purview sensitivity label policies to require users to provide a justification when removing a label or lowering its classification. T...vvargasv14 hours agoMicrosoft EmployeeNew11Views0likes0CommentsVisual Type Defaults in Visualization Pane
This would change my life with fussy clients and client/public facing apps. In addition, it would allow me to add more value to the clients on retainers who do not have the 'hours' to allocate to...IolaWhiteley15 hours agoAdvocate IINew50Views7likes0CommentsMatrix: 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 ...Sayurivalente15 hours agoRegular VisitorNew79Views6likes1CommentAllow Bookmarks to Affect Multiple Report Pages
Description: I would like to request the ability for a single Power BI bookmark to affect and maintain a state across multiple report pages, rather than being limited to a single page. For example,...Josegonzalez2115 hours agoNew MemberNew20Views4likes1CommentFeature Proposal: Expandable/Collapsible Page Sections for Reports on Same Semantic Model
Subject: Feature Proposal: Expandable/Collapsible Page Sections for Reports Using the Same Semantic Model Dear Microsoft Power BI Team, I would like to propose an enhancement to the Power BI report...Dr7awb15 hours agoNew MemberNew32Views1like1Comment