Dashboard refresh issues

Question

Hello,&nbsp;I'm struggling with PBi to show data from last month by default either in reports and dashboard. I've seen some different techniques:&nbsp;1. Creating a column with CurrentMonth and put it on a page/report filter.Problem: I want a slicer with different months, and with this page filter slicer only show CurrentMonth.&nbsp;2. With that same column, having a slicer with CurrentMonth.In Dashboard view there is no slicer... graphs will always refresh with information from last month or&nbsp;every month i will have to pin all graphs to Dashboard with CurrentMonth selected in the reports (2nd option is not a solution obviously)?&nbsp;Could you please help finding the right direction? Thanks.

umerqadir · Answer

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.&nbsp;1) I created calculated tables for each of the times I want to see using a formula like&nbsp;Last x&nbsp;days = DATESINPERIOD(time[Date],max(time[Date]),-x,DAY)&nbsp;2) then I added a calculated column that had a title field with a hard coded value like "Last x days"&nbsp;3) similarly I made a table alldates&nbsp;&nbsp;Alldates = SELECTCOLUMNS(time,"date",time[Date])&nbsp;4) then I added a similar&nbsp;column to this table "All"&nbsp;5) Finally I created a table that was a union of all these tables,&nbsp;and I used the title column to create a slicer&nbsp;Table = UNION(Alldates,'Last 30 days','Last 7 Days','Last 90 days')&nbsp;*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.&nbsp;- I hope this gives you an idea which you can replicate in your own scenario

greg_deckler · Answer

Typically it looks something like creating a new column with a formula like:&nbsp;DaysPast = DATEDIFF([Date],TODAY(),DAY)You can then set your filter to something like &gt;30

gonrodrigues · Answer

But then everything will be filtered right? Slicers included.. I want slicers to have other months/years in the options and not only '&lt; 30'

greg_deckler · Answer

Use a visual level filter then versus a report or page filter.

gonrodrigues · Answer

That doesn't work either. When i select other month in slicer, graph show no data because is filtered :S&nbsp;I need all graphs to show last month by default, but also be able to show data from other months.&nbsp;Thanks&nbsp;Greg_Deckler

Forum Discussion

Dashboard refresh issues

5 Replies

Related content

Refresh issue

Usage Metric report Refresh Issue

Refresh Issue

Incremental Refresh Issue

Auto refresh issue