Create slicer with Custom Time Periods in PowerBI | Time Intelligence | MiTutorials

Create slicer with Custom Time Periods in PowerBI | Time Intelligence | MiTutorials

[LearnShare]

Always loved your creative solutions to real life problems, keep it up!

[prateekkumar-xcuo]

Very knowledgeable video, this will definately going to help in our daily PBI work, thanks for providing such a useful tutorial looking forward for more such videos

[battenarajesh]

Great Thanks. It was closed to my requirement and very useful.

[gareth]

There seems to be a big bug with this that when the custom date still affects the other periods if the custom date does not cover the date range of the preselected.
Maybe i have done something wrong, otherwise this method doesnt really work

[Muffin_Pants]

Great tutorial, and thank you for explaining what the DAX is doing. My question is what would you do differently for multiple years?

[blanchebayla]

This is awesome👏. Big thanks for this tutorial👌👍

[mrrafael]

This tutorial is almost 100% copy from other user's tutorial called custom period slicer in Power BI | Custom date which was created much earlier than this video.
The other thing I've noticed is the measures for Last 10 Days and Last 15 Days should have less then < Today (not less than or equal to Today). If they're <= Today, the number of days we get is actually 11 and 16.

[twkyoscr]

I have been looking for something like this! Genius!

[prabhatn]

Great tutorial.
Is that possible to change the Logic of QuarterToDate where Quarter Starts from July 1st?
And how to Add "ALL" in the Slicer as well?

[Kanchankumari-ltip]

Could you please help me how to sync two slicers with the main table and calendar table. I am trying to create a dashboard that includes two slicers and a tab to select a time period (day, week, month, custom). In the "week" tab, there should be two slicers with options as follows:

**Slicer 1**:
- Last 7 days
- This week
- Last week

**Slicer 2**:
- Preceding period
- Four weeks ago
- Preceding year
- 52 weeks ago

I need a line chart that displays revenue over time, with days on the x-axis. This chart should allow me to compare the revenue for the selected options from the two slicers, such as comparing revenue from the "Last 7 days" to "Four weeks ago."

[MD-kvgc]

HOw are you getting the datesbetween slicer to grey out/empty using the date_disabled measure? When I try this, the values in that slicer remain visible (although can't be typed over) but the user can select the calendar button with mouse and change dates causing unwanted behaviour.
Am I missing something?

[alexdicastelo]

Great video! Thank you for all the explanation! What would be the dax measure if I want to display last 13 weeks?

[LordSheog]

Great video, it really helped me! How can I set up the slicer so that it filters my graph to show everything due in the next month?

[divyajain]

Hi, can you tell me if I need to switch the KPI value based on these fields (in my case, it's Month or Quarter), how exactly do we do because DAX measure is not working 😞

[naveensagar]

If select the custom filter and select the date range between 1-Nov-2022 to 30-Nov-2022 and again go to period selection and select the MTD, without clearing the Custom filter. it won't show the Value.
Is it possible to Clear the Custom filter automatically when we select the Period filter like MTD, QTD...

[jakeg]

If you've multiple tables in your model and use one standard date table how would this work?

[Harika]

I like your video but when you used the slicer range data changed once you back the mtd the slicer was not disabled is it possible to create

[rashidkhan]

great video, how can we make another slicer which could control daily, monthly & quarterly ?

[jayashreeveer]

Getting The syntax for ')' is incorrect. (DAX( VAR Period_Selected = Error

[mnedix]

Great tutorial, but could you please show how you would also add an "All time" selection which is basically the chart you started with?