Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Dear Team,
I have a date slicer on the page, I would like to select automatically most recent date(Max date) in the slicer when users open the dashboard. Can please help to share the logic. Apprecite the help!
Thanks
Solved! Go to Solution.
Thanks a lot, Sergii24. It works! I would like to show the maximum date as a date value,
example : Maximum date 14/09/2023 , is this possible, please. thanks
I'm glad it helped, @Guru123 ! Unfotunately you can't add the date itself there as the whole concept is to make sure that your slicer value is static (so doesn't change after refresh).
You can add a "selected period" label somewhere in your report to underline what date is selected.
Remember to mark answer as solution so others can easily find it if the face a similar problem 🙂
Have a great day!
Ugh - why do so many simple things require half-assed workarounds in PBI?
Hi @Guru123
I've also faced a similar problem previously and wanted to add Max week, and Max month as options in the Date slicer.
I've found a Custom visual from Powerviz - named Date Picker.
It allows to have all of these preset in-built and has lot more features with free trial option.
You can check it out at https://shorturl.at/pAM18
Hi @Guru123, filtering a dynamic date by default is a tricky thing! The biggest problem is not in defining a logic to select a specific date or date range, but in getting rid of previos label. For example, today your max date is 14/09/2023, so you creare a measure that gives you a desired result and the report is filtered as expected. However, tomorrow, when your measure will correctly point to 15/09/2022, the previous label of 14/09/2023 will remain selected (even if this date doesn't exist in your report anymore!). You'll need to select another value from a filter to make disappear "14/09/2023".
To overcome this problem, I would suggest you to create a calculated column in your Calendar Table, where for max date you'll return a label "Maximum date" and for the rest rows - corresponding date from a date column. In such you, "Maximum date" label will remain static (so there is no need to unclick it every day) but will point to different date depending on report refresh (remember that calcualted column value is calcualted when you refresh a report).
Calculated column code:
Date for filter =
VAR _MaxDate = MAX( 'Calendar Table'[Date] )
RETURN
IF(
'Calendar Table'[Date] = _MaxDate,
"Maximum date",
FORMAT( 'Calendar Table'[Date], "dd/mm/yyyy" )
)
Thanks a lot, Sergii24. It works! I would like to show the maximum date as a date value,
example : Maximum date 14/09/2023 , is this possible, please. thanks
I'm glad it helped, @Guru123 ! Unfotunately you can't add the date itself there as the whole concept is to make sure that your slicer value is static (so doesn't change after refresh).
You can add a "selected period" label somewhere in your report to underline what date is selected.
Remember to mark answer as solution so others can easily find it if the face a similar problem 🙂
Have a great day!
Can you please elaborate this approach what you mean there?
I tried your above suggested solution but I want to use my slicer in "Between" slicer style since the date range is really long. Now because the calculated column now becomes a text column, it wouldn't work for this style.
If there is a way that I can manipulate tmy slicer to show the last date value by setting an underlying value or filter somehow in a between style slicer, I would be great.
Hi @swathisudheer, the idea of this approach is to have a some static value filtered, so whenever you refresh a report it remains invariate (even if behind the scene the date or date range has changed).
Because of using a static string value, a new calcualted column is not of type Date anymore but Text. Therefore, you can't expect the same behavior as if it would be a date type column when using this column in a slicer. I don't think it can be changed as you can't mix different data types in the same column.
I hope it helps!
Hi Swathi,
Even I am using the same "Between" Style in my Date Slicer - Whenever I am manually refreshing the Data, then The Upper Limit in the Date Slicer is not getting updated to the latest date - It is still showin the Old Date
Please refer to this YouTube video. This may help.
https://www.youtube.com/watch?v=D4AF9lQCick
Brilliant, yet so silly.
To summarize: Add the date slicer, but don't touch it after that, and it will dynamically adjust.
Thank you 😊
In Power BI, you can set a default maximum date (Max date) in a slicer by using the "Default Value" property of the slicer. Here's how you can do it:
Now, to set the default maximum date, you have a few options:
Option 1: Fixed Date
Option 2: Calculated Date
=MAX('YourTable'[YourDateColumn])
Option 3: Relative Date
=TODAY()
Choose the option that best suits your needs and enter the appropriate value or DAX expression. After setting the default maximum date, the slicer will automatically show that date when users open the dashboard in Power BI.
Remember to save your report after making these changes to preserve the default maximum date setting.
Absolute Tosh
If you dont know what you are talking about you shouldnt post
Too many cowboys in the Analytics world
I do not see 'Default Value' under General
This is literal nonsense.
Date slicers don't have this field. You've clearly just tried to chase clout by posting an AI generated solution.
@Hi @123abc, I didn't know that default value option existis in format pane! Would you be so kidn to send a screenshot where I can find it? I've tried to follow your suggestion but even search doesn't provide me any value for a sting "default" within the list of available formatting items...
Thank you!
Indeed it doesn't exists, ChatGPT can be wrong sometimes...
Well what he is expaining is what chatGPT says, but it doesn't exist, indeed! Neither in PowerBi Desktop nor in PowerBi Service, but I would very much wanted to be wrong.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
90 | |
88 | |
83 | |
64 | |
49 |
User | Count |
---|---|
127 | |
108 | |
87 | |
70 | |
66 |