cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mmace1
Impactful Individual
Impactful Individual

Date Slicer that supports specific dates, but also simple buttons (LastYR, Last365, etc.)

Something like this, where one can select a button for common date ranges, but also input any 2 dates, if they so wish. 

Example.PNG

 I could use a combination of the Defalt Date Slicer, with the default Date Slicer in relative mode.  But that causes 2 issues: 

  • The only date displayed, is that which falls under both slicers (in the below example - that'd be 0 dates)
  • The contradcitory date ranges that could be displayed

Relative plus manual.PNG

For comparision, right now I have the (imo) pretty slicer below.  But two issues: 

  • No way to select any 2 specific dates
  • Writing measures for it requires an additional step, which I don't really want to force on others

    Pretty.PNG

 

Possibly I could do something using buttons + bookmarks - but my pages already rely on bookmarks quite a bit, so I'm leery of complicating things more.  And again, something I don't like about my 'pretty' slicer above, is that it makes things a bit harder on others, if they want to build something. 


3 REPLIES 3
V-lianl-msft
Community Support
Community Support

Hi @mmace1 ,

 

You have mentioned all the workaround😄,If dataset is small, I will create some new columns as slicer options. Then use  "Chicklet Slicer".


Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Greg_Deckler
Super User
Super User

@mmace1 I feel like you nailed it with the buttons + bookmarks approach unless you can find a fancy date slicer in customer visuals.


@ me in replies or I'll lose your thread!!!
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Learn Power BI 2nd Edition
mmace1
Impactful Individual
Impactful Individual

@Greg_Deckler  Thanks.  The issue with bookmarks + Slicers, is one would have to update the bookmark each time. 

 

i.e. here's a boomark for the last completed month - one would need to update that bookmark on Sept 1st, and that's not scalable. 

It could work, if the idea was to have buttons to bookmarks, and a *relative* date slicer, but the goal is to have buttons + a manual date slicer. 

This is pretty darn close.  But requires users, when using custom dates, to clear the custom-slicer, before going back to the buttons. 

https://www.youtube.com/watch?v=fKygF7VEJnQ&feature=youtu.be

Helpful resources

Announcements
June 2022 update 768X460.jpg

Check it out!

Click here to read more about the June 2022 updates!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power BI Dev Camp Session 23 768x460.jpg

Check it Out!

Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!

June 20 episode 7 with aka link 768x460.jpg

The Power BI Community Show

Join us on June 20 at 11 am PDT when Kim Manis shares the latest on Azure Synapse analytics, the Microsoft Intelligent Data Platform, and notable Power BI Updates from Microsoft Build 2022.

Top Solution Authors
Top Kudoed Authors