Forum Discussion

vanessafvg's avatar
vanessafvg
Community Champion
9 years ago
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?
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi tried the formula but got this error: "The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value."

Here's my formula: Current Month = CALCULATETABLE(hd_backorders, FILTER(ALL(hd_backorders), FORMAT(hd_backorders[hd_estfulfillmentdate], "mm yyyy") = FORMAT(TODAY(), "mm yyyy")))

dawidvh's avatar
dawidvh
Helper I
7 years ago

Hi everyone.

 

This functionality hasn't always been there, but if you have a proper formatted date column or better a dedicated date table, you can simply use the relative date filtering. See below:

 

Relative Date Filtering Power BI