topic Date button -1 day and +1 day in DAX Commands and Tips

Date button -1 day and +1 day

Anonymous — Fri, 24 Apr 2020 08:10:24 GMT

Table visualization report with 3 sets of data.

Filtered SalesDate column with filter type: Top N, Top 1. So it always shows the latest days data.

For example data goes from 01.jan - today. Filter shows only 23.04 ( latest data was yesterdays data ) but now I need a way to be able to click through days with a button, like back and forth button adding or subtracting 1 day at a time.

I looked into bookmarks but since my default view is changeing everyday I dont know how set filter to show data 2 days ago. I tried looking into DAX to somehow show the default data -1 day but couldn't find anything helpful.

Re: Date button -1 day and +1 day

Pragati11 — Fri, 24 Apr 2020 08:32:18 GMT

Hi Anonymous ,

Can you please explain your issue in detail by sharing some screenshots and smaple data?

Thanks,

Pragati

Re: Date button -1 day and +1 day

Anonymous — Fri, 24 Apr 2020 08:48:34 GMT

Table that shows looks something like this: ( data showing managed by filter - 23.04.2020 )

data1	521512	51252155	7753223
data2	989124	79151008	7693263
data3	852185	59128521	0521585
data4	592152	58258581	8558215

Date table with values ( not shown on the table visualization like above but used as a filter )

20200424

20200423

20200422

20200421

Filtered like this: ( this filter gives me the results in 23.04.2020 )

Now I need a button idealy like this:
[<-] back 1 day button
[->] forward 1 day button.

Default view should always show the data like in the filter ( latest days data ) like it is now.

Need a back button when pressed it would go back 1 day and show data in 22.04.2020. Click it 1 more time it shows 21.04.2020 data etc. I can not make a new bookmark and have it show 22.04.2020 data in Basic filtering because it would work today but tomorrow is a new day and then it would still bring back to 22.04.2020 but for tomorrow it should bring back to 23.04.2020.

Re: Date button -1 day and +1 day

Anonymous — Fri, 24 Apr 2020 11:55:44 GMT

Why can't you use slicers? Just try to find a slicer in the App Store that does at least approximately what you want. By using bookmarks alone you won't achieve it.

Best
D