Forum Discussion
Community Championignoring 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 to not apply to this one visual.
this is my calculated column value but its not working, its not ignoring the date filter on thage page
RAGs This Year = CALCULATE(VALUEs(Rag[Rag Status]), FILTER(all('Date'), 'Date'[Year] = year(TODAY())))
in the table i can see this is working, but when i add it to the visual it still removes all other dates
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.
4 Replies
v-danhe-msftMicrosoft Employee
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
- Stachu
can you share sample data?
in general calculated column should not be affected by slicers, so I think you will need measure - v-danhe-msft
Hi vanessafvg,
Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?
Regards,
Daniel He
- vanessafvg
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.
