Slicer with AND to only filter certain lines

[RWalet]

Hi,

I am currently designing a dashboard for our project manager, everything is nearly finished besides one thing which I cant seem to find out how it can be done in PowerBI. So here is the scenario:

I have a table 'Job Planning Lines' which contains data regarding, budget lines, planned activities and timesheet lines. So we have the following lines on the dashboard:

Task no.	Line type	Date	Resource	Work type	Hours
1	Budget + Billable	29-6-2021	AB1	D	2
1	Budget	24-6-2021	ZDEV	D	-2
1	Budget	29-6-2021	AB1	(blank)	2

The problem is, that our project managers dont want the see the last lines, the one without a Worktype if the date has past, but they still want to see the lines that do have a Worktype. Idealy they can use a slicer or any other functionality to set the date that they want you use on this particular filter so i just doesnt use today's date as part of the filter.

 I tried getting the date from a slicer and use that as part of a filter/measurement, but without any luck. It would be awesome if i could get some help with this!

Thanks in advance

Robert-Jan

[v-yalanwu-msft · Accepted solution]

Hi, @RWalet ;

You could could a calendar date as a slicer , and then create a flag measure :

1.create a calendar date table.

slicer = CALENDAR(DATE(2021,6,29),DATE(2021,7,31))

2.create a flag measure .

flag = IF(MAX('Table'[Date])<MAX('slicer'[Date])&&MAX([Work type]) =BLANK(),1,0)

3.apply the measure into the filter.

The final output is shown below:

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@RWalet , You can visual level filter on work type not blank.

I am not able to relate with your today's logic

[RWalet]

@amitchandak, Thank you for your quick answer, just filtering on the work type wont work, because that will also remove the lines in the future, and the project manager still want to have those visible.

So with the example above, if the date is past 29-07 they want to have the bottom line filtered out but still have the the othters lines visible. IF there was an additional line on th 31-07 with no Worktype than that line should still need to be visible.

Hope that clears it a bit up.