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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

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
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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