Filter by today or selected date on the same page?

[Jasonvl]

Hi,

I have a dataset that updates every day and the values change daily. I'd like the users via the report page only, to be able to choose to show today's data or go back historically and look at another date? I can achieve this using two different versions of the same report but not one report because the filters conflict with each other. Is there a way around this please?

So to clarify ideally there should be a single calender dropdown (like the ones that appear in the date filters but one date box instead of a start and end date box) which defaults to today's date everytime the data is refreshed and then the user can just choose a historical date if they want to see a snapshot of the data in the past.

Regards, Jason.

[v-juanli-msft · Accepted solution]

Hi @Jasonvl 

As amitchandak suggested, you could use a relative slicer to show today's data by default, then select any other date range from relative slicer, or change to other type of slicer to select some specific date points.

Or you could add measure into page level filter or visual level filter to filter the page or visual to show specific data.

for example, if there is no selection from the slicer, the table shows today's data by default,

if any selection is chosen from the slicer, the table shows data as the selected data.

is any date selected = IF(ISFILTERED('Table 2'[Date]),1,0)

show which date =
IF (
    [is any date selected] = 0,
    IF (
        MAX ( Query1[new date] )
            = TODAY (),
        1,
        0
    ),
    IF (
        MAX ( Query1[new date] )
            <= MAX ( 'Table 2'[Date] )
            && MAX ( Query1[new date] )
                >= MIN ( 'Table 2'[Date] ),
        1,
        0
    )
)

"Table(2)" has no relationship with other tables.

[Date] slicer is from "Table(2)".

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Jasonvl , you can something a column like this

Is Today = if('Date'[Date]=TODAY(),"Today",[Date]&"")

Date needs to be sort column of this and you can select today.

https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column

You can explore relative date slicer

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