Forum Discussion

Koritala's avatar
Koritala
Post Patron
9 months ago
Solved

Custom Date Slicers

Hi All, I need the urgent help in custom date slicer.   User want to have a radio button slicer it should have MTD and Custom values. when user selected the MTD option, the calendar date picker s...
Need Help
  • tharunkumarRTK's avatar
    tharunkumarRTK
    8 months ago

    Koritala 

    As mentioned in my last response, you can achieve it using bookmarks.
    In the PBIX which I shared, boomarks are created and you can refer it 

     

     

     

    Connect on LinkedIn

     

     

     








    Did I answer your question? Mark my post as a solution!
    If I helped you, click on the Thumbs Up to give Kudos.

    Proud to be a Super User!
tharunkumarRTK's avatar
tharunkumarRTK
Super User
9 months ago

Koritala 

1. Create an MTD flag column in your date table  using M language or DAX

2. Create two bookmarks
MTD: with a drop down slicer and a visual level MTD flag = TRUE filter 

Custom bookmark with a Between type date slicer 

As far as I know with native power bi slicers its not possible to change the type of a slicer from Between to dropdown or vice versa based on the selection of a value in another slicer. With bookmarks you can achieve it

 

 

 

 

Connect on LinkedIn

 

 

 








Did I answer your question? Mark my post as a solution!
If I helped you, click on the Thumbs Up to give Kudos.

Proud to be a Super User!
Koritala's avatar
Koritala
Post Patron
9 months ago

Hi Tharun,

In your pbxi file, when MTD selected, it is showing all the dates for the current month instead of showing first date to today's date. can you plz review once and let me know?

Regards,

Sri

  • tharunkumarRTK's avatar
    tharunkumarRTK
    Super User
    9 months ago

    Koritala 

    Just update the MTD flag logic 

    Table.AddColumn(
    #"Changed Type",
    "MTD Flag",
    each [Date] >= Date.StartOfMonth(Date.From(DateTime.LocalNow()))
        and [Date] <= Date.From(DateTime.LocalNow()),
    type logical
)

     

     

     

    Connect on LinkedIn

     

     

     








    Did I answer your question? Mark my post as a solution!
    If I helped you, click on the Thumbs Up to give Kudos.

    Proud to be a Super User!