Skip to main content
Microsoft Idea

Power BI

Needs Votes

Allow Users to Change Date Slicer Type

Vote (97) Share
Nathan Patrick Taylor's profile image

Nathan Patrick Taylor on 21 Dec 2017 03:26:24

Allow users to change the type of date slicer from a default setting to any one of the options (between, before, after, list, dropdown, relative). Currently, once the report is published, users can only change the date slicer from the published setting to a new setting by editing the report. The problem we are having is that we want live tiles to use the "Relative" setting, so the current month is displayed, but allow users to select a specific date range within the report.

Comments (26)
Nathan Patrick Taylor's profile image Profile Picture

on 10 Feb 2022 21:50:37

RE: Allow Users to Change Date Slicer Type

Allow changing, also in Reading view of a report, the "type" of Date Slicer, as it is done in Edit mode.
The end-user will be able to select whether he wants to filter based on relative dates or if he wants to specify exact date in between mode, for example.

Nathan Patrick Taylor's profile image Profile Picture

on 10 Feb 2022 21:50:21

RE: Allow Users to Change Date Slicer Type

The date slicer has an option in the slicer header to change the slicer type (e.g. Between, Before, After, Relative, etc.). This option is only available in Power BI Desktop. When a report is published to the service, the slicer header is still visible, but only the "clear selection" option remains.

Nathan Patrick Taylor's profile image Profile Picture

on 10 Feb 2022 21:50:19

RE: Allow Users to Change Date Slicer Type

Hello,

It would be great if users viewers can change date slicer's type (select the type of slicer) from between to relative (and so on).

Nathan Patrick Taylor's profile image Profile Picture

on 10 Feb 2022 21:50:19

RE: Allow Users to Change Date Slicer Type

Currently you can switch between the date slicer type in the desktop file e.g. change between relative and between.

This feature is not available in the service for some reason in read mode?

Please make this an option as to end users this is really powerful. This makes no sense to me why it wouldn't be an option to end users

Nathan Patrick Taylor's profile image Profile Picture

Max F. on 21 Dec 2021 07:16:05

RE: Allow Users to Change Date Slicer Type

Good Idea. It would be the best, if users could just click on the range of the relative date slicer and then a dropdown calendar opens like in the between slicer. This way users don't mess up the type, but still can choose between a relative range or a custom range.

Nathan Patrick Taylor's profile image Profile Picture

Max F. on 21 Dec 2021 07:14:16

RE: Allow Users to Change Date Slicer Type

I would appreciate this feature a lot. Users want to select between a relative date and a range. Best way to implement it, would probably be to choose relative date slicer for your report, where the range gets displayed after selecting a time unit. If users click on the range they can define a custom one like they can do with the between slicer.

Nathan Patrick Taylor's profile image Profile Picture

Jan R on 10 Jun 2021 12:18:52

RE: Allow Users to Change Date Slicer Type

would be highly appreaciated. if you have a lot of pages with synced slicers, using bookmarks is very cumbersome

Nathan Patrick Taylor's profile image Profile Picture

Jan R on 10 Jun 2021 12:14:55

RE: Allow Users to Change Date Slicer Type

here is the same idea that has currently the most vote: consider to concentrate votes in one place
https://ideas.powerbi.com/ideas/idea/?ideaid=6666707b-ad78-450c-898d-7e4961b76155

Nathan Patrick Taylor's profile image Profile Picture

Corey Dupuis on 14 May 2021 23:40:47

RE: Allow Users to Change Date Slicer Type

Great idea.

It's also duplicated here with more votes:
https://ideas.powerbi.com/ideas/idea/?ideaid=6666707b-ad78-450c-898d-7e4961b76155

Nathan Patrick Taylor's profile image Profile Picture

Corey Dupuis on 03 May 2021 19:48:55

RE: Allow Users to Change Date Slicer Type

Another vote. My users are requesting the ability to change between a relative date (last month) and between (a date range).

Merged Idea (6)