Data from always TODAY in Dashboard

[Frixel]

Hi all,

If I have a report where new data is added daily with the date in column A, how do I always get the current date of today in a dashboard?

[v-shex-msft]

Hi @Frixel,

You can also add 'today' filter in the query editor side.

Steps:

1. Enter to query editor and click on the date field that you want to filter records and choose one date to apply filter.

2. Modify on formula bar to replace that value with Date.From(DateTime.LocalNow())

Notice: My table does not contain today value so it has been filtered as blank, this filter will update based on your system DateTime.

Regards,

Xiaoxin Sheng

[Frixel]

Hi @v-shex-msft 

I don`t get the formule bar, how do i get it?

[v-shex-msft · Accepted solution]

HI @Frixel,

You can click on 'view' menu to find out the option to open formula bar or click on the advanced editor to check these formulas and modify them.

Regards,

Xiaoxin Sheng

[ibarrau]

Hi, in order to have today's data in a dashboard you need to filter a visualization by today before pinning it to the dashboard. You can check this post about relative date to understand how you can filter by "this day" and a lot more.

https://docs.microsoft.com/en-us/power-bi/visuals/desktop-slicer-filter-date-range

Regards,