Forum Discussion

Koritala's avatar
Koritala
Icon for Post Patron rankPost 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
    9 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!
Koritala's avatar
Koritala
Icon for Post Patron rankPost 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
Icon for Super User rankSuper 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!