set default start date as current month start date and end date as today in date slicer

[Sowjanya_1]

I have date slicer which coming from date column. currently date slicer is showing some random start date and end date 

Constraints

• I can manually change the start/end date in the same date slider. When we open the report for the first time the default date range should be current month.
• If data not available for current month then also by default it should show start  and end date to current month start date and Today date.

[Sowjanya_1]

Hi @Idrissshatila ,

Thanks for your solution.Unfortunatly it is not suitable for my date slicer.My date slicer is in below format.

And one more thing i'm working in direct query mode.

Regards,
Sowjanya.

[Idrissshatila]

Hello @Sowjanya_1 ,

check this https://youtu.be/JlVHsZUk1nc

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin