topic Re: How to show latest date as default selection in a slicer. in DAX Commands and Tips

How to show latest date as default selection in a slicer.

Prasad23 — Wed, 31 Jan 2024 11:31:07 GMT

Hi Team,

Please help me out with this query.

How to show latest date as default selection in a slicer.

For Example, we have a date column contains date from 01-10-2022 to 22-12-2023. So, when i drag to slicer i need to show defalut selection as 22-12-2023.
If user need to select other date he need select. otherwise it should be default.

Thanks & Regards,

Prasad

Re: How to show latest date as default selection in a slicer.

Anonymous — Thu, 01 Feb 2024 02:59:17 GMT

Hi Prasad23

Maybe this method will help you.

Sample:

Then I created a calculated column as follows.

Date1 = IF('Table'[Date] = MAX('Table'[Date]), "Latest Date", FORMAT('Table'[Date], "MM-DD-YYYY"))

Then use this newly created column in the slicer.

Select Latest Date to automatically select the latest date when adding new data to the table.

When I didn't update the data:

When I updated the data:

Is this the result you expect?

Best Regards,
Community Support Team _Yuliax

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: How to show latest date as default selection in a slicer.

Prasad23 — Thu, 01 Feb 2024 04:04:46 GMT

Hi 123abc ,

Thank you,
I didn't understand this point,

Set Default Slicer Selection: Now, go to the Visualizations pane, find your slicer, and drag the "DefaultSelection" measure to the "Default value" field. This will set the default selection of the slicer to the latest date.
Could you please explain this point where i need to keep this "DefaultSelection" measure.

Regards,
Prasad

Re: How to show latest date as default selection in a slicer.

Prasad23 — Thu, 01 Feb 2024 04:07:03 GMT

Hi Anonymous ,

Thank you, Is there anyway can we get instead of "latest date" text to Date value.

Like "Latest Date" replaces with 12/23/2023.

Regards,
Prasad

Re: How to show latest date as default selection in a slicer.

Anonymous — Wed, 10 Jul 2024 16:34:04 GMT

can you explain point 3 in more details? I dont find the default value field not. Or do you mean drag and drop additionally to calculated column field the measure?

Re: How to show latest date as default selection in a slicer.

Bozintheuk1 — Mon, 23 Sep 2024 07:27:11 GMT

I agree with Anonymous . I dont see a "Default value" field. All the other steps work just fine!

123abc Can you help to clarify since I am not the only one that doesnt see this.

Re: How to show latest date as default selection in a slicer.

alex_powerbi_20 — Thu, 17 Oct 2024 12:39:59 GMT

Same as the first two replies - I am unable to follow part 3 as I'm unable to locate a "Default value field":

Set Default Slicer Selection: Now, go to the Visualizations pane, find your slicer, and drag the "DefaultSelection" measure to the "Default value" field. This will set the default selection of the slicer to the latest date.

Re: How to show latest date as default selection in a slicer.

FADAVI — Wed, 18 Dec 2024 09:48:52 GMT

His answer has a chat GPT pattern. That won't help you, there is no default value field

Re: How to show latest date as default selection in a slicer.

gmsamborn — Sun, 22 Dec 2024 02:06:45 GMT

Agreed.

It seems @abc123 is taking the LAZY way out.

abc123 should have at least tried to verify any AI content before using it.

Re: How to show latest date as default selection in a slicer.

IanTCC — Thu, 23 Jan 2025 10:18:34 GMT

abc123 Why would you do this? Please don't post misinformation - this really is unhelpful to the community. If you insist on using GPT to augment your brain, at least fact check the results first. <reported to moderator>.

Re: How to show latest date as default selection in a slicer.

123abc — Thu, 23 Jan 2025 14:54:02 GMT

You are right but its my old post now i am not useing GPT and AI tools and if used any AI tool then mentioned the source. But i extremely apologies for this inconvenience.

Re: How to show latest date as default selection in a slicer.

123abc — Thu, 23 Jan 2025 14:54:15 GMT

You are right but its my old post now i am not useing GPT and AI tools and if used any AI tool then mentioned the source. But i extremely apologies for this inconvenience.

Re: How to show latest date as default selection in a slicer.

Natalie_iTalent — Tue, 28 Jan 2025 16:20:12 GMT

Hello IanTCC,

Thank you for letting us know. The response has been removed from this post. We appreciate your contributions.

Best,

Natalie H.

Community Manager

Re: How to show latest date as default selection in a slicer.

AJColt1953 — Fri, 14 Feb 2025 11:11:30 GMT

I edited the example from 'v-xuxinyi-msft' above to format the MAX value isntead of returning TEXT in the iftrue part of the IF function, example below:

Date1 = IF('Table'[Date] = MAX('Table'[Date]), FORMAT(MAX('Table'[Date]), "MM-DD-YYYY"), FORMAT('Table'[Date], "MM-DD-YYYY"))

This works for me and defaults the max value to the date format I require.

Regards

Re: How to show latest date as default selection in a slicer.

Amarjit — Thu, 10 Apr 2025 16:04:31 GMT

Hi,
Are you getting the Max Date as the default date selected with this approach?