Select most recent date (by default) in slicer

[Fab117]

In my database (Excel), I’ve a column with a date

Type:

Extract date	Parameter	Value	…
15.12.2023	X	1
15.12.2023	Y	2
15.12.2023	Z	1
15.01.2023	X	2
15.01.2023	Y	3
15.01.2023	Z	1
15.02.2023	X	2
15.02.2023	Y	1
15.02.2023	Z	2

In my report I’ve a dropdown slicer which let me select extraction date I want to look at.

Is it possible to have by default the most recent date selected?

Tks.

Fab

[Fab117]

Hi @Anonymous 

This solves perfectly my issue.

Thank you very much for looking at my request and sharing the solution.

Would it be possible for you to explain me how the formulae (n°4 in your tuto) is working?

Have a great week-end

Fab

[Anonymous]

Hi @Fab117 ,

I hope these are helpful to you:

Preselected Slicer | INSIDERS.COOP Power BI Custom Visuals (insiders-coop.github.io)

MAXX function (DAX) - DAX | Microsoft Learn

IF function (DAX) - DAX | Microsoft Learn

Best Regards,

Neeko Tang

[Anonymous · Accepted solution]

Hi @Fab117 ,

According to your description, here are my steps you can follow as a solution.

(1) This is my test data.  

(2) We can create a table.

Table 2 = {TRUE(),FALSE()}

(3)As shown in the following image, add a "Preselected Slicer" visual.

(4)We can create a measure.

Measure = var a=MAXX(ALL('Table'),[Column1])
return IF(MAX([Column1])=a,TRUE())

(5) Then the result is as follows.

Best Regards,

Neeko Tang

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

[Fab117]

I found a perfect solution with my demo file.

Unfortunately, it doesn’t work with my production file.

Methodology:

I put my card (pointing on Extract date field) over my slicer (in the top right corner).

I apply transparent background on it, adjust font size and no border

Next step is to apply a function on the font color for the value of the card:

Black if “Extract Date v2” field is “Latest Extract Date”

White for any other value

It’s working properly on my demo file, but not with my production file.

First issue, when I select the “Extract_Date” field, it mentions “Count of Extract Date”

And then, only Summarization options I have are Counting

... in next post (Server Too busy)

[Fab117]

... follow up from previous post

And then, only Summarization options I have are Counting

Do someone know why this difference and how to solve it?

Tks.

Fab

[Fab117]

Hi,

I’m nearly there.

In Data View, I created a new column to identify the nearest date with formula

Extract Date v2 = if('Sheet1'[Extract date]=Max('Sheet1'[Extract date]),"Latest Extract Date", FORMAT('Sheet1'[Extract date], "DD-MM-YYYY"))

Then I point my slicer to new column “Extract Date v2”

I select “Latest Extract Date” cell and save. Now, when report will be launched, my slicer will always point on “Latest Extract Date” which will be automatically updated if new data’s are added in my data base.

Remaining issue: I don’t know what is behind “Latest Extract Date”? Which date is it?

Ideal solution would be to have the corresponding date (field “Extract date”) mentioned somewhere in the slicer. Something like:

NB: I didn’t find a way to do it.

[Fab117]

Alternative would be to add in my report a card with the correspondence using value from “Extract date” field:

However, this makes sense when user stays on “Latest Extract Date” in the slicer, but if user select another date, it’s useless

For this, I tried to play with the Selection and Bookmarks panes, but was unsuccessful:

If someone knows how to do it, would be much appreciated.

Fab