Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Filter Multiple Date Columns in One Slicer

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 i...
Need Help
  • edhans's avatar
    edhans
    7 years ago

    I think you need to transform your data in Power Query first.

    Here is a sample of your data (I just keyed some stuff in)

    I then selected all of the columns except the recruiter, and on the Transform tab, select Unpivot Column. Then I renamed the columns to make more sense and got this:

     

     

    Now, import that into Power BI, and link the date column to a date table in Power BI (See this article if you need help with a date table).

     

    Then put the date, or month, or quarter, or whatever, from the date table into your slicer, and the functions (screening, test, etc) and the recruiter names in your visuals, and the date slicer will cause your other visuals to show all related items about that time period. So if Month is in the slicer, all January items would show up in the visual if you selected January in the slicer.

edhans's avatar
edhans
Icon for Community Champion rankCommunity Champion
7 years ago

I think you need to transform your data in Power Query first.

Here is a sample of your data (I just keyed some stuff in)

I then selected all of the columns except the recruiter, and on the Transform tab, select Unpivot Column. Then I renamed the columns to make more sense and got this:

 

 

Now, import that into Power BI, and link the date column to a date table in Power BI (See this article if you need help with a date table).

 

Then put the date, or month, or quarter, or whatever, from the date table into your slicer, and the functions (screening, test, etc) and the recruiter names in your visuals, and the date slicer will cause your other visuals to show all related items about that time period. So if Month is in the slicer, all January items would show up in the visual if you selected January in the slicer.