Forum Discussion
Solved
dynamically filter visual by current month?
Whats the best way to filter a visual to data from only the current month. Would it be to create a measure filtering on latest month or is there an easier way?
Hi vanessafvg,
You can simply to create a calculated table to filter data with today function, then use this new table as the source of visual.
Current Month = CALCULATETABLE(DateTable,FILTER(ALL(DateTable),FORMAT([Date],"mm yyyy")=FORMAT(TODAY(),"mm yyyy")))
Notice: original datetable contains date from 2015 to 2017, after above steps, it only contains current month data.
Regards,
Xiaoxin Sheng
Create a calculated column on your date table to identify current month and past month.