Forum Discussion
Dashboard refresh issues
Hello, I'm struggling with PBi to show data from last month by default either in reports and dashboard. I've seen some different techniques: 1. Creating a column with CurrentMonth and put it ...
Typically it looks something like creating a new column with a formula like:
DaysPast = DATEDIFF([Date],TODAY(),DAY)
You can then set your filter to something like >30
But then everything will be filtered right? Slicers included.. I want slicers to have other months/years in the options and not only '< 30'