I can't get my filter to show current date so I can have the visual show the currents date data

[Anonymous]

I can't get my filter to show current date so I can have the visual show the currents date data when refreshed daily. So I have a graph that shows targets met per month, I used a simple filter and manually selected the days to show on the visual, so now I want to add a filter that will show currents month data that will automatically change everyday showing the months progress everytime the data is refreshed. I don't want to manually open PBI to select current date on filter to show on the visual, I would like this to happen automatically. so in summary I would like to have this in one graph, I would like to have pre-selected dates(filtered dates - Sept,Oct,Nov) and one live data(that changes everytime when theres new data for December)

[amitchandak · Accepted solution]

@Anonymous , You need to create a column like this in you date table and use that and save on this month

Month Type = Switch( True(),
eomonth([Date],0) = eomonth(Today(),-1),"Last Month" ,
eomonth([Date],0)= eomonth(Today(),0),"This Month" ,
Format([Date],"MMM-YYYY")
)

Default Date Today/ This Month / This Year: https://www.youtube.com/watch?v=hfn05preQYA