Forum Discussion
Dashboard refresh issues
That doesn't work either. When i select other month in slicer, graph show no data because is filtered :S
I need all graphs to show last month by default, but also be able to show data from other months.
Thanks Greg_Deckler
I have done something similar in my case where I wanted to have a slicer with last 7 days, last 30 days and last 90 days and an All dates element to it.
1) I created calculated tables for each of the times I want to see using a formula like
Last x days = DATESINPERIOD(time[Date],max(time[Date]),-x,DAY)
2) then I added a calculated column that had a title field with a hard coded value like "Last x days"
3) similarly I made a table alldates
Alldates = SELECTCOLUMNS(time,"date",time[Date])
4) then I added a similar column to this table "All"
5) Finally I created a table that was a union of all these tables, and I used the title column to create a slicer
Table = UNION(Alldates,'Last 30 days','Last 7 Days','Last 90 days')
*Please note that you will have to define the relationship between the final table and the data tables you want to filter in order for this to work either through the time dimension table or directly.
- I hope this gives you an idea which you can replicate in your own scenario