Create MTD/QTD/YTD Time Intelligence Slicer in Power Bl Using Date Picker 11-03-2023 05:44 AM - last edited 11-07-2023 05:30 AM

[kavitabehera15]

I'll explore an efficient way to create slicers in Power BI for easy switching between QTD (quarter-to-date), YTD (year-to-date), and MTD (month-to-date) periods without the hassle of selecting start and end dates manually.

Here are the steps to create Date Picker Presets:

1. Ensure you have a date column in your dataset.
2. Import the Date Picker by Powerviz and drag the date field onto your report.
3. Open the settings and navigate to Presets
   a. Select "This Month" for "MTD."
   b. Select "QTD" for "QTD."
   c. Select "YTD" for "YTD."
4. Apply and save your settings.

You now have the flexibility to customize the design and themes to align with your preferences. Your clients can effortlessly select their preferred time periods while enjoying a smooth and user-friendly interface. It's as simple as that.

Let me know if you need the sample file.

eyJrIjoiMDhmMzU5MWUtN2MxZC00MDEyLWE1NGQtOGU0YmYxYTg3YmFmIiwidCI6ImNhODc1ZjVhLTcwNmMtNDFmNS04YTczLWNlMTQ0ZjMxMDhlMyIsImMiOjF9&embedImagePlaceholder=true

[paulojorge1]

please share ty

[kavitabehera15]

I have updated it in the content. Please check

[KotKot]

please share the sampole file thanks

[kavitabehera15]

Hi, I have updated it in the above sample file. Please check.