topic Re: Filter Multiple Date Columns in One Slicer in Custom Visuals Development Discussion

Filter Multiple Date Columns in One Slicer

Anonymous — Fri, 12 Apr 2019 08:58:42 GMT

Hi guys,

I am trying to solve this for a while and couldn't get a solution. I work in recruitment and I have to make daily/weekly/monthly reports on the recruiter's activity. I have 45 columns in Power Bi full of date/time that describe an action that was made by a recruiter, for example, if a candidate passes from Test to Interview, in the Interview column will appear the date and time when this change was made.

This is a simplified sample of what I got, I put colors for each month to be more clear.

And this is how 2 of the columns look in reality.

Can I make a slicer that would filter every action that was made between 2 certain dates, in all the 45 columns?

For example, in the simplified version, I want to see how many actions have been made in January (gray), or February(green) in each column, by each recruiter?

In my real report, it should display something like this, here I used as reference one column of dates like "Candidate Submit Date", but it doesn't give me a real-time activity of recruiters as if a candidate submitted a month before I set up a date in a slicer, the activity for that specific candidate will not appear, even though he passed through some processes between the dates I choose and it's a faulty report.

The reason I insist on the slicer method and not a formula is that I want all the recruiters and recruitment managers to be able to use the slicer themselves and export the data they need without my assistance.

If you have any ideas or need further information, please let me know.

Thanks a lot for your assistance!

Re: Filter Multiple Date Columns in One Slicer

v-evelk — Fri, 12 Apr 2019 14:43:39 GMT

Hi,

I suppose you need to have some separate column that will contain every date that presented in your table and use it for a slicer.

AllDates	Screening	Offer	Hired	CandidateID
1/19/2019	1/19/2019	null	null	1234
3/24/2019	null	3/24/2019	null	1234
4/15/2019	null	null	4/15/2019	1234

Kind Regards,

Evgenii Elkin,
Software Engineer
Microsoft Power BI Custom Visuals
pbicvsupport@microsoft.com

Re: Filter Multiple Date Columns in One Slicer

Anonymous — Sun, 14 Apr 2019 17:31:25 GMT

I moved the topic here:

https://community.powerbi.com/t5/Desktop/Filter-Multiple-Date-Columns-in-One-Slicer/m-p/669410#M322055

Sorry for the inconvenience, I'm new around here :)

Re: Filter Multiple Date Columns in One Slicer

v-evelk — Tue, 16 Apr 2019 14:39:27 GMT

It's Ok, if you question is out of our expertise we will redirect you into corresponding thread anyway :)

Kind Regards,

Evgenii Elkin,
Software Engineer
Microsoft Power BI Custom Visuals
pbicvsupport@microsoft.com

Re: Filter Multiple Date Columns in One Slicer

Anonymous — Wed, 17 Apr 2019 09:16:21 GMT

Thank you, v-evelk

Can someone delete this thread? I received a solution on this link: https://community.powerbi.com/t5/Desktop/Filter-Multiple-Date-Columns-in-One-Slicer/m-p/669416#M322058