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
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
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."
Hello sir How to create custom time silcer? I have daily data of 24 hours and need only specific 16 hour data to present I.e. 19:00ET -10:00ET Plz answer
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...
After selecting CUSTOM filter when you go back to let's say QTD the chart does change. Only the dates on the second slicer stays visible. You can choose to disable the calendar slicer when anything else is selected other than custom. Please see the video below. th-cam.com/video/g-4w8Wp0bqg/w-d-xo.html
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?
hi bro, thanks for the sharing. but i want to know how if i want to create the slicer with the values not like that, but let says, Monthly, Quarterly, Yearly. the context is, i have a chart, actually combo chart for seeing the actual and target qty. for the axis i want to use slicer, if i select monthly the visual will be show by monthly, if quarterly will be quarterly etc. could you help me with this?
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 😞
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
I noticed that it's only working where you have date on X or Y axis on the visual. How should make it work for Pie Chart, ScoreCard, Matrix etc visuals. Thanks
I have the same query: Hi, can you tell me if I need to switch the KPI value on the card visual based on these fields (in my case, it's Month or Quarter), how exactly do we do because DAX measure is not working 😞
Hello, i have LY sales and CY Sales in seperate table. I want to show the YTD & MTD along with last years sales. How will i do it using this formula, i tried this but it’s giving me only the CY.
great video, but I dont know what I am missing. I am not able to load the visual. It is stating that you can't compare date with text and my dataset has historical dates between 2013 and 2015. I can't use Today() function in that case. How to resolve this? Please advise.
I don't know, but I can't make the custom date slicer disappear when the other options are selected, although I added Disable Date Slicer as a filter to the visual. Is someone facing the same issue?
Hi, great tutorial. My company do not use calendar month and year as fiscal but rather we use fiscal months that ends on the LAST saturday of each months. As per the fiscal year it ends on the last Saturday of November. Therefore I can not use the Power BI build in EOM and EOY functions. Would you make a video to show how one can have a custom End of month and End of year?
I find a big issue with this solution - once you set a new date range in "custom", that date range persists, even when you choose "Month To Date", etc. For example, Let's pretend today is January 10. if you first choose a Custom range from say, Dec 1-Dec 31, and get the results.... then you choose "month to date", You will get no results because the Dec-1-Dec 31 range is still applied. You still need to change the date range in Custom to be in January, in this example, otherwise it returns nothing.
Thank you for this amazing Video !!! But i have a problem. I did it like your describe, BUT when i choose "Custom" and set a date ( for Example 01.01.2024 - 03.01.2024) and choose after that "MTD" or "Last 10 Days", the Custom Data slicer keep the date (01.01.24-03.01.2024) . It does not reset like in your vidoe. , although i coose "MTD" or the others. Do you know, why?
Facing the same issue... If a short date range is selected and then we try to see qtd or mtd the chart is not getting updated.. Please do let me know if you get any solution
this has loop hole. if you select custom and change daterange value and when you reselect Last 7 days. ideally you should get date values as blank but it hold the changed custom value
When I am at this part of the coding, th-cam.com/video/Xi86HHEaY_M/w-d-xo.htmlsi=9d-FKDrUvbO1CcoM&t=388, I get a syntax error. I have checked it several times, and it will not work.
Always loved your creative solutions to real life problems, keep it up!
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
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
Exceptional Video content
Great Thanks. It was closed to my requirement and very useful.
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."
This is awesome👏. Big thanks for this tutorial👌👍
Excellent tutorial!
All makes sense.
I have been looking for something like this! Genius!
Hello sir
How to create custom time silcer?
I have daily data of 24 hours and need only specific 16 hour data to present I.e.
19:00ET -10:00ET
Plz answer
thank you, very clear and useful!😊
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...
After selecting CUSTOM filter when you go back to let's say QTD the chart does change. Only the dates on the second slicer stays visible.
You can choose to disable the calendar slicer when anything else is selected other than custom. Please see the video below.
th-cam.com/video/g-4w8Wp0bqg/w-d-xo.html
For me exactly the same... So far have no idea how to fix it
@@MITutorials this is not at all help my questions
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?
hi bro, thanks for the sharing. but i want to know how if i want to create the slicer with the values not like that, but let says, Monthly, Quarterly, Yearly. the context is, i have a chart, actually combo chart for seeing the actual and target qty. for the axis i want to use slicer, if i select monthly the visual will be show by monthly, if quarterly will be quarterly etc. could you help me with this?
U r deserves to subscribe ur channel.....subscribed👍👍👍
Getting The syntax for ')' is incorrect. (DAX( VAR Period_Selected = SELECTEDVALUE(Slicer[order_by]))). Error
did u solve it ? getting same error
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 😞
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
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?
If you've multiple tables in your model and use one standard date table how would this work?
I noticed that it's only working where you have date on X or Y axis on the visual. How should make it work for Pie Chart, ScoreCard, Matrix etc visuals. Thanks
I have the same query:
Hi, can you tell me if I need to switch the KPI value on the card visual based on these fields (in my case, it's Month or Quarter), how exactly do we do because DAX measure is not working 😞
Great tutorial, and thank you for explaining what the DAX is doing. My question is what would you do differently for multiple years?
Add a timeline custom slicer which is available in the store.
Hello, i have LY sales and CY Sales in seperate table. I want to show the YTD & MTD along with last years sales. How will i do it using this formula, i tried this but it’s giving me only the CY.
If I want to see a single month data then what can i do in this code?
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
Fantastic! Thank you so much.
Does anyone know how I can display the data at the start and end of the line chart in this work in particular?
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?
Great video! Thank you for all the explanation! What would be the dax measure if I want to display last 13 weeks?
You could probably just apply one of the solutions used here with 13*7 = 91 days instead.
how can i add this month and this year in the slicer
great video, but I dont know what I am missing. I am not able to load the visual. It is stating that you can't compare date with text and my dataset has historical dates between 2013 and 2015. I can't use Today() function in that case. How to resolve this? Please advise.
Informative 😍
great video, how can we make another slicer which could control daily, monthly & quarterly ?
There is a calendar visual available in the MS store. Pretty good you can use that.
I don't know, but I can't make the custom date slicer disappear when the other options are selected, although I added Disable Date Slicer as a filter to the visual. Is someone facing the same issue?
agreed - I can't get it to disable. The date range is valid in the filter no matter which period I choose.
@@terryhikes me I had to redesign my whole report to work around this problème.
It will not slow the report???
Sir please explain how to create relationship between these multiple tables.When i clic
k filters its not showing.
Great tutorial, but could you please show how you would also add an "All time" selection which is basically the chart you started with?
Hi, I am getting invalid number argument using above dax please help
I also have the same problem did you solve it already?
Yes I am getting the same thing when I am at the VAR part
Hi,
great tutorial.
My company do not use calendar month and year as fiscal but rather we use fiscal months that ends on the LAST saturday of each months. As per the fiscal year it ends on the last Saturday of November. Therefore I can not use the Power BI build in EOM and EOY functions. Would you make a video to show how one can have a custom End of month and End of year?
Please see this tutorial.. if this does not help let me know.
th-cam.com/video/IWzshpThV7k/w-d-xo.html
I find a big issue with this solution - once you set a new date range in "custom", that date range persists, even when you choose "Month To Date", etc. For example, Let's pretend today is January 10. if you first choose a Custom range from say, Dec 1-Dec 31, and get the results.... then you choose "month to date", You will get no results because the Dec-1-Dec 31 range is still applied. You still need to change the date range in Custom to be in January, in this example, otherwise it returns nothing.
Need a way to "reset" or "blank out" the date range inputs when you first click on any option besides "Custom".
Thank you for this amazing Video !!! But i have a problem. I did it like your describe, BUT when i choose "Custom" and set a date ( for Example 01.01.2024 - 03.01.2024) and choose after that "MTD" or "Last 10 Days", the Custom Data slicer keep the date (01.01.24-03.01.2024) . It does not reset like in your vidoe. , although i coose "MTD" or the others. Do you know, why?
Facing the same issue... If a short date range is selected and then we try to see qtd or mtd the chart is not getting updated.. Please do let me know if you get any solution
Great content!
I need to calculate HTD(Hour), DTD(Day), WTD(Week), MTD(Month), YTD(Year) & Custom. Please guide.
Excellent
👍👍👌👌
Good but Iam getting error like dax operations donot support values of type date with type text
Looks like your date column has data type text! Check the data type of your columns.
how to write dax for previous month and this month as slicer selection
See the below video and play around with the code and then add that code to the slicer selection.
th-cam.com/video/h_0v3rRDgU4/w-d-xo.html
this has loop hole. if you select custom and change daterange value and when you reselect Last 7 days. ideally you should get date values as blank but it hold the changed custom value
right i have faced the same thing... can you please check it
How can i get wtd?
no easier solution for a standard date slicer ?!!!
You should use a table instead of graph. Can’t verify or see what you are doing
When I am at this part of the coding, th-cam.com/video/Xi86HHEaY_M/w-d-xo.htmlsi=9d-FKDrUvbO1CcoM&t=388, I get a syntax error. I have checked it several times, and it will not work.
12:50
5:17
🤕🤒