Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
EquipoPowerBI
Frequent Visitor

Filtro Fechas- Siempre la ultima fecha cargada con opcion al resto

Buenos días,

Por favor si alguien nos puede ayudar con este tema:

 

Tenemos un filtro de fechas que muestra y permite seleccionar cualquier fecha dentro del ultimo año.......pero necesitamos que cuando el usuario abra el informe, en el filtro, por defecto aparezca la ultima fecha cargada ..(cada día se cargan los datos del día anterior).

Es posible hacer esto???

Muchas gracias por la ayuda.

Un saludo

 

1 ACCEPTED SOLUTION
v-easonf-msft
Community Support
Community Support

Hi, @EquipoPowerBI 

Are you referring to dynamically setting the default value of the slicer to display the data for the last loaded date?

As a workaround, you may need to create an additional custom date column in your original Calendar table to tag the "last loaded date". Then apply this new filed to the slicer.

You can refer to similar tutorials below.

How to set a DATE SLICER to TODAY by default in Power BI 

 

Best Regards,
Community Support Team _ Eason

View solution in original post

2 REPLIES 2
EquipoPowerBI
Frequent Visitor

Thanks ¡¡¡ Thanks¡¡¡¡ Thanks ¡¡¡

It works and the explanation is crystal clear and very hepful....

v-easonf-msft
Community Support
Community Support

Hi, @EquipoPowerBI 

Are you referring to dynamically setting the default value of the slicer to display the data for the last loaded date?

As a workaround, you may need to create an additional custom date column in your original Calendar table to tag the "last loaded date". Then apply this new filed to the slicer.

You can refer to similar tutorials below.

How to set a DATE SLICER to TODAY by default in Power BI 

 

Best Regards,
Community Support Team _ Eason

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.