Skip to main content
Microsoft Idea

Power BI

Merged

Allow Slicers to be preset based on defined criteria

Vote (165) Share
David Wilson's profile image

David Wilson on 07 Aug 2018 03:20:44

Allow Slicers to be preset based on defined criteria (i.e. DAX formula or other developer input).

For example, a dashboard that displays KPI data based on the current week end date. On displaying the dashboard the screen should default to the current end date with the user having the optional ability to set the date slicer for previous weeks.

At a stretch you could have a button with a bookmark action to run some DAX that could set the date slicer to the latest end date.

Taking this further you could also reverse and forward the slicer to the next selection (via DAX or other command/action).