Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Proud to be a Super User!
Solved! Go to Solution.
@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.
Proud to be a Super User!
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
@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.
Proud to be a Super User!
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
can you share sample data?
in general calculated column should not be affected by slicers, so I think you will need measure
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |