I love that in all your videos you purposefully keep the steps that won't work and correct them in the following steps. This is great because it is how most of us approach things and so we don't just learn the final solution but also your approach to fix half working things which we can apply in other scenarios.
Nice way around it ! A customer asked me to create a dashboard that when it opens shows always the current month. So i created a column : s_currentMonth = if( year(t_comp_time[DTIM_DATE]) = year(TODAY()) && month(t_comp_time[DTIM_DATE]) = Month(TODAY()), "Yes","No") And i put this column in a different slicer next to the date slicer. There the custoemr can select : current month : "yes" or" no". I saved it as "yes" and uploaded it. I guess you can do the same thing for the current day.
Thanks - the solution is great and helped me to complete my use case. I wasn't able to utilize your solution directly for "Between" date slicers, but instead I slightly modified your calculated column DAX code and created a measure by combining "INT ( NOT ( ISEMPTY ("Date calendar")))" and that calculated column. That measures provides as results 1 (=calculated column row has data) and 0 (=blank rows) and I added it as a visual filter for the "Between" slicer. Generally a big thanks for your videos - love it that you are showing your steps / way of thinking and coming to the end result clearly. In additional to practical examples, you are my go-to PBI RUclipsr for hands-on visual tips.
Hi :) Glad to find your comment. I am currently facing the same problem. Is there a chance to see your DAX code? I couldn't understand how you combined author's code and code mentioned by you. Thanks in advance!
Those error messages can be very frustrating 😀 happy to hear this helped a bit! Let me know if you have some that pop up regularly then I will do a video on how to tackle the most common error messages.
The "why does this work 🤷♂️" made me audibly laugh. That is so very Power BI. I have also been trying to do this forever so this video is a lifesaver.
Thank you for your apport. This is the things I hate from PowerBI, instead of be a simple checkbox on the Slicer settings we have to do all this tricky stuff.
I have done something similar to this but on the month and year levels for slicers. For example, I build a "Current Month" value and a "Current Year" value for my month and year slicers so that when the report is published, it automatically shows the current month and year's data. I have also built a "Last Month" value for those who want to build a Power BI Service bookmark for last month reports.
@@azrijasni2005 sure. You will need a date dimension table. Simply replace your date column in the code snapshot below: Current Month Slicer = // Will need a YearMonthInt (YYYYMM) column to enforce sort order VAR CurrentMonth = FORMAT( TODAY(), "YYYYMM" ) VAR LastMonth = FORMAT( EDATE( TODAY(), -1 ), "YYYYMM" ) VAR DateFormatted = FORMAT( 'Date'[Date], "YYYYMM" ) VAR IsCurrentMonth = DateFormatted = CurrentMonth VAR IsLastMonth = DateFormatted = LastMonth VAR MonthFormatted = FORMAT( 'Date'[Date], "mmmm YYYY" ) VAR Result = SWITCH( TRUE(), IsCurrentMonth, "Current Month", IsLastMonth, "Last Month", MonthFormatted ) RETURN Result
I see people are still commenting on this GREAT video. One question is, Customer really doesn't want to see "Today" in the slicer but today's date.. Anyone know of a way to use the method but "show" the actual date in the slicer?
Nice trick! As an alternative for sorting you can also create a "Slicer Date Sort Order" column where you store the numeric date for the dates less than or equal to today and the same numeric value (f.i. numeric value for today + 1) for all other days. You can now sort the "Slicer Date" on the "Slicer Date Sort Order" column. This will always work even in the case when Microsoft should fix the "the feature" you use to sort the "Slicer Date" on the "Day" column where the values for the "Day" column are not unique for each value in "Slicer Date".
Hi Bas, nice trick. I am trying to adapt to my issue, which is show yesterday selected by default. But I don`t want to show "yesterday" in the slicer but the day of yesterday in text format. Is it possible to do that with this technique? Thank you
Hello I like this approach but same thing can we achive it by powerquery? I know how to do that for today but not able to implement it if I have to choose the dates from the slicer.. Any of such videos can be useful.. Thanks in Advance..
Awesome :) funny i wrote my code almost similar to your solution (before watching your video) but for the current year and you nailed that mystery I had on how to do it as a String value as the column contains both number and string :D thanks for sharing!
That's excellent..however what if your dim date comes from sql server (like mine does) and doesn't get generated using the calendarauto function? Is there a workaround for that scenario?
You could show "#" & [Date] for future dates, then filter not to show those starting by "#"... as all the "Slicer dates" will be different, Sort by column would work
Hi, would something like this work on a from and to date slicer? Keeping the from date at a fixed point but making the to date dynamic to today’s? Thanks tom
Thanks for the video, maybe someone can help me, in addition to displaying the current date in the slicer, how can I display the last 15 calendar days by default? and if the client wants to go beyond that, they can do so. Thank you so much
Hi, Can we Crete on dates between the same , when open the report in slicer slicer shows to day date after we need select dates range in that slicer is it possible?
The other solution is to create a custom sort byy column which uses a formula which coverts the date to serial date and adds -1,000 to future dates so they go down to the bottom of the list.
I love the sort by column hack, but I didn't build my date table the way you did. Could I still find a way to solve the problem? Is there a link to some video/page?
Here we have to selct today, but in my circumstance, i shouldn't select today but it should select automatically today's date..is there a way means kindly suggest me
Kudos to you Bas! Can you use date hierarchy here (monts/dates - a bit cleaner and smaller list in the slicer) and how about the Date before today analogy?
Thanks a lot for the video. Is there a way to add a column if a date column has already been created by other ways. As my slicer keeps show last year 9/1/2021 to 9/30/2021 instead of 9/1/2022 to 9/30/2022. How can do do this. I tried many but did not work. regards Linda
Hi, great content. I'm running trough an issue based on my timezone. My bi works perfectly until I publish it and the timezone taken is UTC as a standard. therefore my "Today" slicer shows no data after 8PM because is assuming that's already the next day. Is there a way to make the calendar know that we are in EST and not UTC.
I use a column “future” that is true for all dates after today and I filter the page/visual for future = false. Similar column I use is “current year” to make the report page change year automatically when I want it (non necessarily on start of year)
thank you for this great video, could you please let me know how we can put slicer for current week and current month in one slicer at the same time, and then choose one we need?
Hi Atefeh, thx a lot! you can put your date column on the slicer, hover over it and click on the downward pointing arrow .. then from the list, choose relative date slicer where you can choose this week or month
Great Content as usual Bas ! Have you think about a solution creating buttons to navigate between the days ? Imagine probably some, -1 day , +1 day buttons to create a friendly UX to the end user. Please let me know if you already know a work around for this, Thank you so much for all your videos.
I have a date slicer which should show last 12 months as selected when report opens. Further, user should have flexibility to select any other date range. Please any one answer this question
I don't think this is possible with the current features. You can go for the relative date slicer, but there is no way yet to reset to last 12 months on report open. 🙁
Hi i like all ur videos... its really informative..need ur help.. I nees to change default year from Jan to December to July to june for all calculations. how can i do
Similar can be used if you want to have it for the month, you just need to adapt the formula a bit. For example: IF( MONTH(dimDate[Date])=MONTH(TODAY())&&YEAR(dimDate[Date])=YEAR(TODAY()), "Current Month", IF( dimDate[Date]
I keep seeing this king of tricks for setting a default value on slicers, and ok, it works, but I really miss a native way of telling Powerbi what the deaulf value is, for example with some sort or a query,especially if I don't want/or can't replace the date with "today". Nice video anyway. It'd be nice if MS would give us a way to set this without hace to do magic tricks with Dax and replacing our data with keywords.
You can always use Power query to define a column flagging which row is today’s date and select it in slicer. Other date column can then act as sort by column. with conditional column, it can be used to define multiple conditions to exclude future dates if needed.
I have a custom date table with our own Company periods i.e. Period 11 runs 25th April 2021 to 22nd May 2021. How can I do this so the slicer is on our custom Period? Would there need to be a lookup to the period aligned to Today?
HI Sir, I tried making a date slicer column in my date table with today and other dates in if else function as stated but it returns me an error sating "Multiple Columns cannot be converted to scalar value".Any help would be great!
I need show line chart to latest 3 months and using sync slicer if I put default to latest 3 months it's syncing with other pages.just show latest 3 months by default and let the user select the month from slicer.is this possible?
This worked for me in the beginning, but then it stopped working. The slicer is set to the last time I picked a date after refreshing it, but it doesn't advance by itself. When I click on the calendar icon, the current date is available as an end date, but it doesn't pick it visually. Hope that makes sense. Why do you think it stopped working? This is the code: Slicer Date = IF( [Date]
how can i change default date on slicer date calendar, there have 2 calendar that from and to date calendar. just i date filed drag and drop on slicer. automatically set date value on calendar. would you give me your any video link that i can able to change default date and set my desire date as default date calendar. but by default all data load on table, when i click or change calendar value then will effect on table data. advance thanks
Has anyone had an issue when publishing online? This works on desktop but then my slicer gets destroyed on PBI Online. For example, the “Today” row in my sliced completely vanishes or selects the wrong date as Today (maybe time zone differences). Can’t Figure out why this is happening.
Hi - thanks for the great solution. When I used this DAX, my new [Date Slicer] came out in US format 04/17/2022 even though my original [Date] is 17/04/2022 (I'm in Australia and we use UK date format). Would anyone know how I can fix it? Thanks :)
Hi Great and informative tutorial. A small question. We have future dates as well in the date list and based on a requirement that I have the date slicer should be in between format and also by default the date range is the first day of the current year to today. Can you pls explain a workaround for that ...Thanks a lot in advance...
with the between format the solution in the video won't work. You could consider an option like shown in this video ruclips.net/video/fKygF7VEJnQ/видео.html
@@HowtoPowerBI You lovely video bound me to subscribe your channel.. Not only for the your magic trick but also the helpful link you have provided here.. Keep it up ...
go to the model tab -> select the date field you want to format -> go to formatting in the properties pane -> choose custom format -> type in dd/mm/yyyy
But using this we can select only one filter at a time?? Seems I cannot select multiple values even after my report loaded and shown data for current date. So, its not supporting multiple filters if we need other dates data including todays data.
Hi, great video and really useful hack for the date ordering, thnks for this. is there any way to automatically have Today as the selected item (when the report is opened)? Cheers
Nice video. Is it possible to have a slicer to show today as default when nothing is selected? What I mean is a DAX formula like "if nothing is selected in the slicer then show me today's data". Thanks
Hi what if I want the default date as YTD and the last day is today(503/2022) in list sync with year on other tab. Please refers to the screen shot (unable to paste print screen) but it looks like: ---------------------1/1/2022 (in a box) to ---------------------today's date(5/3/2022)
you can use the same logic just adjust the if statement to something like this: IF( YEAR([Date])=YEAR(TODAY()) && MONTH([Date])=MONTH(TODAY()), "CurrentMonthYear",
nice video... can you make a video on start date, end date and between dates. by default current date is default in start date and when user select a date should be from selected date to 6months forward and if user selects end date should be selected date to 6months backward and default is 6months. If user selects between range then should be in that range. This is a common requirement to everyone but don't find a video...Kudoos if you can do
Hi @@HowtoPowerBI , it really very nice video , but I am also looking for solution for between where end date should always be max date or today date. if this video already created ?
I love that in all your videos you purposefully keep the steps that won't work and correct them in the following steps. This is great because it is how most of us approach things and so we don't just learn the final solution but also your approach to fix half working things which we can apply in other scenarios.
That table revision to hard code just to get the 'sort by column' to work was an outstanding move. Immediately subscribed.
Thx for your sub!
7:44 I just smiled and shook my head. That workaround is magical. So glad I found this channel.
Nice Workaround !! Thank you for also showing all your process to set this up, and explaining why others tricks won't work !
Glad it was helpful! thanks for watching! 🙂
Another brilliant idea .hope one day they add default settings to slicer ! thanks for sharing.
Nice way around it ! A customer asked me to create a dashboard that when it opens shows always the current month.
So i created a column :
s_currentMonth = if( year(t_comp_time[DTIM_DATE]) = year(TODAY()) && month(t_comp_time[DTIM_DATE]) = Month(TODAY()), "Yes","No")
And i put this column in a different slicer next to the date slicer.
There the custoemr can select : current month : "yes" or" no". I saved it as "yes" and uploaded it. I guess you can do the same thing for the current day.
Thanks - the solution is great and helped me to complete my use case. I wasn't able to utilize your solution directly for "Between" date slicers, but instead I slightly modified your calculated column DAX code and created a measure by combining "INT ( NOT ( ISEMPTY ("Date calendar")))" and that calculated column. That measures provides as results 1 (=calculated column row has data) and 0 (=blank rows) and I added it as a visual filter for the "Between" slicer.
Generally a big thanks for your videos - love it that you are showing your steps / way of thinking and coming to the end result clearly. In additional to practical examples, you are my go-to PBI RUclipsr for hands-on visual tips.
Hi :)
Glad to find your comment. I am currently facing the same problem.
Is there a chance to see your DAX code? I couldn't understand how you combined author's code and code mentioned by you.
Thanks in advance!
@@saidakbarkhasanov8370 he never answered:(
Best Power BI Tutorials on RUclips! Thank you!!
Very good that you explain and solve these error messages. I faced them often but now I understand why. Thanks
Those error messages can be very frustrating 😀 happy to hear this helped a bit! Let me know if you have some that pop up regularly then I will do a video on how to tackle the most common error messages.
The "why does this work 🤷♂️" made me audibly laugh. That is so very Power BI. I have also been trying to do this forever so this video is a lifesaver.
Hahha :):) happy to hear this
Thank you for your apport.
This is the things I hate from PowerBI, instead of be a simple checkbox on the Slicer settings we have to do all this tricky stuff.
Thanks Bas. I have implemented your technique, in addition I used it to show for the previous 12 months data for any selected slicer date.
Nice idea, keep it up!
I like the way you are explaining Power Bi topics.
Great Video content. Keep it up, Dude.
I have done something similar to this but on the month and year levels for slicers. For example, I build a "Current Month" value and a "Current Year" value for my month and year slicers so that when the report is published, it automatically shows the current month and year's data. I have also built a "Last Month" value for those who want to build a Power BI Service bookmark for last month reports.
can you share how it's done?
@@azrijasni2005 sure. You will need a date dimension table. Simply replace your date column in the code snapshot below:
Current Month Slicer =
// Will need a YearMonthInt (YYYYMM) column to enforce sort order
VAR CurrentMonth = FORMAT( TODAY(), "YYYYMM" )
VAR LastMonth = FORMAT( EDATE( TODAY(), -1 ), "YYYYMM" )
VAR DateFormatted = FORMAT( 'Date'[Date], "YYYYMM" )
VAR IsCurrentMonth = DateFormatted = CurrentMonth
VAR IsLastMonth = DateFormatted = LastMonth
VAR MonthFormatted = FORMAT( 'Date'[Date], "mmmm YYYY" )
VAR Result =
SWITCH(
TRUE(),
IsCurrentMonth, "Current Month",
IsLastMonth, "Last Month",
MonthFormatted
)
RETURN
Result
I applied this to my report today. Thanks for your help.
I see people are still commenting on this GREAT video. One question is, Customer really doesn't want to see "Today" in the slicer but today's date.. Anyone know of a way to use the method but "show" the actual date in the slicer?
We usually put a kpi card on top of the slicer showing the actual date. Unfortunately this looks crap and is hard to align properly
Nice trick!
As an alternative for sorting you can also create a "Slicer Date Sort Order" column where you store the numeric date for the dates less than or equal to today and the same numeric value (f.i. numeric value for today + 1) for all other days. You can now sort the "Slicer Date" on the "Slicer Date Sort Order" column. This will always work even in the case when Microsoft should fix the "the feature" you use to sort the "Slicer Date" on the "Day" column where the values for the "Day" column are not unique for each value in "Slicer Date".
oh nice one, thx for sharing!
Hello, I try to add a filter in ma slicer date start, like today is the end you think it's possible ?
Hi! How do I default the date to yesterdays date please?
@@moiLawUk Pretty sure you figured it out by now - you can simply put "TODAY()-1" in the IF functions.
Is there any way we can use the between-date slicer and take input of both the start date and end date where the End date will always be today?
You have got a amazing ways of explaining.
I'm really enjoying and learning from your videos. Well done!
That's Awesome, thank you for watching!
That sort by column hack was brilliant :D
haha I was surprised myself that that worked 😅 thx Smit
I was exactly looking for it.
Thanks a lot.
You explained it like water❤️
Thank you! Glad it was helpful! 😃
It helped me to solve my problem, thanks for the video and sorting step was awesome, subscribed now
Haha I love the sort hack. That's great. Really enjoy your vids.
Hi Bas, nice trick. I am trying to adapt to my issue, which is show yesterday selected by default. But I don`t want to show "yesterday" in the slicer but the day of yesterday in text format. Is it possible to do that with this technique? Thank you
thank you, I was really need this video
amazing video as usual, i am wondering why your channel does not have 500K subscribers. XOXO
I want to achieve this is date range. By selecting between and I need to dynamically set the start and end date
Two nice tricks in one video! Thank you for sharing these great tips.
Hello I like this approach but same thing can we achive it by powerquery? I know how to do that for today but not able to implement it if I have to choose the dates from the slicer.. Any of such videos can be useful.. Thanks in Advance..
Awesome :) funny i wrote my code almost similar to your solution (before watching your video) but for the current year and you nailed that mystery I had on how to do it as a String value as the column contains both number and string :D thanks for sharing!
nice! happy to hear the video still added a bit to your solution! 😃
That's excellent..however what if your dim date comes from sql server (like mine does) and doesn't get generated using the calendarauto function? Is there a workaround for that scenario?
Amazing as always.🖖
You could show "#" & [Date] for future dates, then filter not to show those starting by "#"... as all the "Slicer dates" will be different, Sort by column would work
Genius! nice one Jaime this works a treat!!!!
Hi Bas, is it possible to adapt todays date as an end date in a between slicer? Looking for an Option for ages.. :(
I need this for a "between dates "slicer. To date should be today and from date should be start of current month.
Awesome lessons as usual. Thank you. Any suggestion on how to have
- today
- last seven days
- last fourteen days
- last month
I don't want to add the latest date label and only date instead of latest. does it work the calculation
excellent!!😍
Hi, would something like this work on a from and to date slicer? Keeping the from date at a fixed point but making the to date dynamic to today’s? Thanks tom
my thoughts exactly. Let's hope someone come up with any idea cose i think i've tried everything
Many thanks,
It was helpful
Thanks for the video, maybe someone can help me, in addition to displaying the current date in the slicer, how can I display the last 15 calendar days by default? and if the client wants to go beyond that, they can do so. Thank you so much
Hi! Thanks for the video. How do I default the date to yesterdays date please?
Hi,
Can we Crete on dates between the same , when open the report in slicer slicer shows to day date after we need select dates range in that slicer is it possible?
Is there also a workaround to do this with the between date slicer?
What if the value is a text? There are 3 values in a slicer A, B , C. How to make either one as Default Thanks for the great vids..love them!
The other solution is to create a custom sort byy column which uses a formula which coverts the date to serial date and adds -1,000 to future dates so they go down to the bottom of the list.
Thx it helps me today!
At 1:45 why don't you set relative date to "Is in the last" 99 years (including Today) ?
Worked great for me, thank you!
Glad it helped!😀
Great!
Could you also tell the same method for default select Current Month and display previous Months.
Use Month(Today()) ,
Evaluate it with your Date dable ,month column .
It will be similar to this.
I love the sort by column hack, but I didn't build my date table the way you did. Could I still find a way to solve the problem?
Is there a link to some video/page?
Here we have to selct today, but in my circumstance, i shouldn't select today but it should select automatically today's date..is there a way means kindly suggest me
What to do if I want to show the max(date ) in the table data? ( Max date is not the day from the Dax: Today()). Thanks!
I need auto previous month slicer what should I do?
nice vid. thanks!
Thx Rein!!! 😀
fantastico...this is brilliant
Brilliant 😎👏🏽🔥
Kudos to you Bas! Can you use date hierarchy here (monts/dates - a bit cleaner and smaller list in the slicer) and how about the Date before today analogy?
I need this but for a "between dates "slicer
Thanks a lot for the video. Is there a way to add a column if a date column has already been created by other ways. As my slicer keeps show last year 9/1/2021 to 9/30/2021 instead of 9/1/2022 to 9/30/2022. How can do do this. I tried many but did not work. regards Linda
Hi can anyone explain how I could this in descending order currently its on supporting in ascending order when i sort the date
Hi, great content.
I'm running trough an issue based on my timezone.
My bi works perfectly until I publish it and the timezone taken is UTC as a standard. therefore my "Today" slicer shows no data after 8PM because is assuming that's already the next day. Is there a way to make the calendar know that we are in EST and not UTC.
Thank you so much! You are briliant
I use a column “future” that is true for all dates after today and I filter the page/visual for future = false. Similar column I use is “current year” to make the report page change year automatically when I want it (non necessarily on start of year)
nice idea 🙂
You´re the best! Just it!
:):) thank you!
any comment on how to set finical year as default
How can I do with this Between days?
I tried the same thing but created the table using generate and since the date is returning text my sort is not working
then create the table like in the video , download link in the description
thank you for this great video, could you please let me know how we can put slicer for current week and current month in one slicer at the same time, and then choose one we need?
Hi Atefeh, thx a lot! you can put your date column on the slicer, hover over it and click on the downward pointing arrow .. then from the list, choose relative date slicer where you can choose this week or month
@@HowtoPowerBI thanks for your kind reply.
Hi BAS,
how to get dynamically maximum date in slicer in dropdown
(i dont want to today in text )
Great Content as usual Bas ! Have you think about a solution creating buttons to navigate between the days ? Imagine probably some, -1 day , +1 day buttons to create a friendly UX to the end user. Please let me know if you already know a work around for this, Thank you so much for all your videos.
Do you have any ideia how to do the same but with current month dates? That is, initialize by default with the current month dates.
You can adjust the formula to return current month in the date table instead of today. Similar logic
Don't wanna see today text, want that date to be shown. Can you pls help on that
I have a date slicer which should show last 12 months as selected when report opens. Further, user should have flexibility to select any other date range. Please any one answer this question
I don't think this is possible with the current features. You can go for the relative date slicer, but there is no way yet to reset to last 12 months on report open. 🙁
Hi i like all ur videos... its really informative..need ur help.. I nees to change default year from Jan to December to July to june for all calculations. how can i do
Thank you for this Awesome Trick..
It will be helpful you could advise me on selecting current month selection in dashboard
Similar can be used if you want to have it for the month, you just need to adapt the formula a bit. For example: IF(
MONTH(dimDate[Date])=MONTH(TODAY())&&YEAR(dimDate[Date])=YEAR(TODAY()),
"Current Month",
IF(
dimDate[Date]
My end users prefer calendar view that you get if the slicer is type of between. How do you get today as default in there?
that is possible if you take the approach suggested by @Ben Rebai Amal -> create a calculated column ‘Today OR Prior’ = if ('Date'[date]
I keep seeing this king of tricks for setting a default value on slicers, and ok, it works, but I really miss a native way of telling Powerbi what the deaulf value is, for example with some sort or a query,especially if I don't want/or can't replace the date with "today".
Nice video anyway. It'd be nice if MS would give us a way to set this without hace to do magic tricks with Dax and replacing our data with keywords.
totally agree 🙂
You can always use Power query to define a column flagging which row is today’s date and select it in slicer. Other date column can then act as sort by column. with conditional column, it can be used to define multiple conditions to exclude future dates if needed.
I have a custom date table with our own Company periods i.e. Period 11 runs 25th April 2021 to 22nd May 2021. How can I do this so the slicer is on our custom Period? Would there need to be a lookup to the period aligned to Today?
THANK YOU! 👏
:) happy to hear it was helpful
HI Sir,
I tried making a date slicer column in my date table with today and other dates in if else function as stated but it returns me an error sating "Multiple Columns cannot be converted to scalar value".Any help would be great!
You have to add it as a new table not a measure or column.
I need show line chart to latest 3 months and using sync slicer if I put default to latest 3 months it's syncing with other pages.just show latest 3 months by default and let the user select the month from slicer.is this possible?
This worked for me in the beginning, but then it stopped working. The slicer is set to the last time I picked a date after refreshing it, but it doesn't advance by itself. When I click on the calendar icon, the current date is available as an end date, but it doesn't pick it visually. Hope that makes sense. Why do you think it stopped working? This is the code:
Slicer Date =
IF(
[Date]
I should note, too, that the date slicers are all sync across pages, all options are checked, and they're in the same slicer group.
Nice!
but, like that, the user cannot select anymore the future, e.g. to see the forecasted value.
If you have a solution for that, let me know :)
Thanks! You could return the date after today instead of a blank,
IF(
[Date]=TODAY(),
"Today",
IF(
[Date]
@@HowtoPowerBI Seems cool :) i will give it a try. Cheers
how can i change default date on slicer date calendar, there have 2 calendar that from and to date calendar. just i date filed drag and drop on slicer. automatically set date value on calendar. would you give me your any video link that i can able to change default date and set my desire date as default date calendar. but by default all data load on table, when i click or change calendar value then will effect on table data. advance thanks
Has anyone had an issue when publishing online? This works on desktop but then my slicer gets destroyed on PBI Online. For example, the “Today” row in my sliced completely vanishes or selects the wrong date as Today (maybe time zone differences). Can’t Figure out why this is happening.
can you make some projects and implementing or showing us all the tricks in one
Just add a bookmark, select the slicer and update the bookmark,more simple way👍
Could explain a bit more, i dont see how it would work
Hi - thanks for the great solution. When I used this DAX, my new [Date Slicer] came out in US format 04/17/2022 even though my original [Date] is 17/04/2022 (I'm in Australia and we use UK date format). Would anyone know how I can fix it? Thanks :)
Why am i getting this error "The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value". pls help
Hi , when the refresh the data set automatically from the SharePoint it is possible to select the date sciler to today()-1
ple help me regarding this
yes, the logic would be the same.
IF(
[Date]=TODAY()-1,
"Yesterday",
IF(
[Date]
Hi Great and informative tutorial. A small question. We have future dates as well in the date list and based on a requirement that I have the date slicer should be in between format and also by default the date range is the first day of the current year to today. Can you pls explain a workaround for that ...Thanks a lot in advance...
with the between format the solution in the video won't work. You could consider an option like shown in this video ruclips.net/video/fKygF7VEJnQ/видео.html
@@HowtoPowerBI Thank you...I'll try on that...
@@HowtoPowerBI You lovely video bound me to subscribe your channel.. Not only for the your magic trick but also the helpful link you have provided here.. Keep it up ...
I have a problem. It shows e first the month and then the day.. but i want it otherwise..like "dd/mm/yyyy".. Any Help?
go to the model tab -> select the date field you want to format -> go to formatting in the properties pane -> choose custom format -> type in dd/mm/yyyy
But using this we can select only one filter at a time?? Seems I cannot select multiple values even after my report loaded and shown data for current date. So, its not supporting multiple filters if we need other dates data including todays data.
it works for me... not sure why it doesn't for you?
Hi, great video and really useful hack for the date ordering, thnks for this. is there any way to automatically have Today as the selected item (when the report is opened)? Cheers
only when it gets saved with today selected - no other way I know of
Nice video. Is it possible to have a slicer to show today as default when nothing is selected? What I mean is a DAX formula like "if nothing is selected in the slicer then show me today's data". Thanks
thx Juan, I think you could achieve that using the function isfiltered()
Thank you
Hi what if I want the default date as YTD and the last day is today(503/2022) in list sync with year on other tab.
Please refers to the screen shot
(unable to paste print screen)
but it looks like:
---------------------1/1/2022 (in a box) to ---------------------today's date(5/3/2022)
Hi ,Is it possible to default the month and Year slicer to current month and Year. If yes can you please tell the solution.
you can use the same logic just adjust the if statement to something like this:
IF(
YEAR([Date])=YEAR(TODAY())
&& MONTH([Date])=MONTH(TODAY()),
"CurrentMonthYear",
nice video... can you make a video on start date, end date and between dates. by default current date is default in start date and when user select a date should be from selected date to 6months forward and if user selects end date should be selected date to 6months backward and default is 6months. If user selects between range then should be in that range. This is a common requirement to everyone but don't find a video...Kudoos if you can do
thanks for the idea, will look into it!
Hi @@HowtoPowerBI , it really very nice video , but I am also looking for solution for between where end date should always be max date or today date. if this video already created ?