I'm designing a daily report displaying data from yesterday. I had this solved by applying a relative date filter in the page level.
Now I would like to give users the possibility to look at former days (individually, meaning just 1 day data) in the same report. In my head, adding a calendar slicer (by the way I couldn't find any for just 1 date, all of the work in ranges) that alters the page level filter will be great, but I couldn't find the way...
Another possibility will be to have a date slicer / picker where you can set 'yesterday' as default, but neither I've found a visual capable of this.
Does anybody have any idea how to solve this? Thanks!
You can try Relative Date Slicer.
Or tell more about your needs, include a sample picture result that you want.
What I would like to have is data displayed for yesterday (that it's not necessary the last day, there could be data "in the future") by default, when the report is opened, and a slicer / calendar that allows me to go back to a certain day to see the data.
I'm still unclear your request. Can you give me your example by picture, or something like pbix file please?
I need to know more about your slicer/trend/ table data,...
No, it doesn't mean yesterday in this case... Last 1 day for a slicer equals to last day with data -1.
If you use report / page / visual filtering using date, you can set "is in the last 1 days" and deativate "Include Today" to have yesterday's, but not in the slicer.
In my case some data is carried over automatically, I've got data until tomorrow 24th November, so date displayed if I try "Last 1 day" is 23th November.
I have dates till the end of 2020 and it does the same for me.
What happens if you do last 2 days?
Maybe try with when you have further ahead dates to be sure
Due to the nature of the data I'm not allowed to share screenshots or pbix files, but I'm attaching a very basic "blueprint".
When you open the report, by default is should display yesterday's date (and data). Using a calendar / slicer, give the user the opportunity to change the date, overriding the default date.
I hope this clarifies my request. Thanks for your help.
It's not always -2 days or there's too much data "in the future" so the filter I'm looking after should be more like Today()-1 rather than relative days using the last date.
Anyway, I have the "yesterday's date" sorted out using a page level filter, but I'm missing a slicer / calendar that could override this filter using user's input.
It looks it's more complicated than I initially expected and it's quite frustrating seeing that other apps like SAS Visual Analytics or Tableau having these features... Unfortunatelly the customer wants Power BI.