Fecha de hoy predeterminada y ademas segmentador de fechas

[César_SF]

Hola a todos😁

Quiero aplicar a mi dashboard algun tipo de solucion que permita tener por defecto el dia de hoy en cualquier pestaña pero tambien tener la opcion de tener un segmentador de fechas por si se quiere cambiar la fecha. todas estas opciones deben estar aplicada a toda la visualizacion,no solo a un grafico en especial.

Espero puedan ayudarme!!😊

[HarishKM]

@César_SF Hello,
I will use below steps to troubleshoot.

1. Ensure you have a date table in your model. You can create a calculated table in DAX with all the dates you might need. I will use below dax for creating a calander
   
   DateTable = CALENDAR( DATE(2020, 1, 1), // Start Date DATE(2050, 12, 31) // End Date )
2. Insert a slicer visual in your report and Set the slicer to use your DateTable column. This allows users to pick any date they wish.
3. Create a measure that identifies today’s date: 
   TodayMeasure = IF( SELECTEDVALUE(DateTable[Date]) = BLANK(), TODAY(), SELECTEDVALUE(DateTable[Date]) ) // This measure will default to today’s date unless a specific date is selected.
4. To apply the date selection to all pages, use the Synchronize Slicers feature. Add your slicer to each relevant page and sync them using the Format pane > Sync Slicers option
5. Use the TodayMeasure in your report visuals to filter data based on the selected or today’s date. (You can incorporate this measure into your filters or measures as needed (e.g., sales data based on the selected date).
6. Make sure your DateTable is properly linked to your fact tables in the data model.
   
   

   Thanks

   Harish KM

   If these steps help resolve your issue, your acknowledgment would be greatly appreciated.

[César_SF]

@FBergamaschi Entiendo, es que solo estoy como editor en este momento.

Entonces si publico un dashboard con una configuracion predeterminada, siempre se mantendra asi almenos que se edite denuevo y se cambie eso.

Los visualizadores del dashboard veran como predeterminado siempre lo que configuro el editor.

[v-menakakota · Accepted solution]

Hi  @César_SF  ,

Thanks for reaching out to the Microsoft fabric community forum. 

I would also take a moment to thank @FBergamaschi  , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference. 

Yes, when a report is published, the slicer selection will stay as the default view. Report viewers will see that default unless they interact with the slicer during their session but those changes won’t affect the default for others.

Only a report editor can change the default by updating and republishing the report.

If I misunderstand your needs or you still have problems on it, please feel free to let us know.   
Best Regards, 
Community Support Team  

[v-menakakota]

Hi @César_SF ,

Can you please confirm whether the issue has been resolved. If you have any additional questions or concerns, please do not hesitate to contact us. We are here to support you and will be happy to help with any further assistance you may need. 

Thank you.

[v-menakakota]

Hi @César_SF ,

I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you.

Thank you.

[César_SF]

@FBergamaschi Pero esto no hace que se tenga por defecto la fecha del dia de hoy al abrir la pestaña. la idea es tener la fecha de hoy como predeterminada al abrir cualquier pestaña y tener tambien el slicer con las demas fechas.

[FBergamaschi]

To my knowledge, if you select "Today" and publish, that value will be retained. Of course, if somebody changes it and saves the report, that value changes, but you can always put it back to today

Otherwise you can apply a filter on a column with Y/N values on the date being today or not but in that case you cannot then change the date

If this helped, please consider giving kudos and mark as a solution

@me in replies or I'll lose your thread

Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page

Consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI

[FBergamaschi]

My suggestion is to create a text column in which yo show the dates as text and today as "today". You can then set the value to today in a slicer and syncronize the slicer in all the pages and you can still change the calue to another date. The text type is needed so that you can have in the same column "Today" and "23 july 2025" for example

If this helped, please consider giving kudos and mark as a solution

@me in replies or I'll lose your thread

Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page

Consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI