Forum Discussion
Conditional filter
Hello 🙂 I have a filter (slicer) on my report for the expected delivery date but in a table we show the desired del. date too. Now I have the question wether it is possible to filter the e...
you could try something like this. But i am not sure it would work for all your scenarior.
Create measure that is like a switch.
Check Planned Date =
IF (
SUM ( Years[Actual Year] ) = SUM ( Years[Expected Year] ),
1,
0
)
IF (
SUM ( Years[Actual Year] ) = SUM ( Years[Expected Year] ),
1,
0
)
then in the filter pane set it to 1
then it will only return rows where the planned date = actual date, this assumes you always have both dates populated and you only ever want to return it where it equals each other. See pbix attached
Thank you but this doesnt solve my problem 😞 because they are often not the same and should only be shown as the same when the filter (slicer) is applied!
I see. You could try something like this with a bookmark
basically you overlay 2 tables and you toggle between them using a bookmark. So when you want all records you use that view, when you only want to see matched you use the other view.
so in the pbix if you press the control button + click on the button it will change the view
see attached
