Automatically mark the first value in a filter.

[Syndicate_Admin]

Good afternoon

I have loaded in a filter object a view with different dates. I would like to know if it is possible to mark when entering the report the most current date loaded in the filter.

Thank you in advance

[v-jingzhang]

Hi @Syndicate_Admin 

I don't 100% understand your requirement. Can you share some dummy data or visuals to describe what you want to achieve? 

Regards,
Community Support Team _ Jing

[amitchandak]

@Syndicate_Admin , There no function support to default value , you can create a flag or column below and default on last date

Is Today = if('Date'[Date]=max(Table[Date]),1,0)

or

Is Today = if('Date'[Date]=max(Table[Date]),"Last Date",[Date]&"")

You can use one them as slicer

[Syndicate_Admin]

Thank you very much, @Syndicate_Admin,

I created the new column with a value of 1 when it's the maximum date and 0 for the rest. Now, how do I automatically select when I load the report what this column equals 1?. I give example:

I now have dates 09/04/2021 and 08/04/2021. In the new column max_fecha, I have the value 1 for 09/04/2021 and the value 0 for 08/04/2021. My goal is that when opening the report dial 09/04/2021 as shown in the image.

Thanks again

[v-jingzhang]

Hi @Syndicate_Admin 

You can refer to this blog: Power BI Tutorial: Dynamically update Date slicer to show Current Date – business intelligist

Currently Power BI will keep the selected value in a slicer. It means when you log out of Power BI and come back to a report, the same items will be selected as when you left. It cannot be updated automatically. So in above blog, it selects a fixed Most Recent Date value in the slicer. Every time the data is refreshed, the Most Recent Date value will be updated.

Additionally, there is an idea about this feature: Microsoft Idea  · Default Selected Slicer or Tile-By Value Configuration (powerbi.com)

Hope this helps.

Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.