Forum Discussion
Automatically mark the first value in a filter.
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
4 Replies
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
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
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.
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
