Forum Discussion

vanessafvg's avatar
vanessafvg
Icon for Community Champion rankCommunity Champion
7 years ago
Solved

ignoring date filter on page

I have a dashboard that is filtered by the last reported date.   however i want to show all the status for a project over a the last year, how do i ignore that filter report date on the dashboard t...
Need Help
  • vanessafvg's avatar
    vanessafvg
    7 years ago

    v-danhe-msft  sorry it looks like i double posted, as i said for visual i just set interactions not to filter for this particular visual problem sorted quick, thanks for the response though.

v-danhe-msft's avatar
v-danhe-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi vanessafvg,

Based on my test, you could create a measure instead of a calculated column:

Sample data:

Create a measure:

Measure = CALCULATE(SUM(Table1[Value]),FILTER(ALL(Table1),MONTH('Table1'[Date])=MONTH(TODAY())))

Result(I have set the page filter):

 

Regards,

Daniel He