Few columns with dates - how to do the slicer which will count the rows from each of the column

[aleksandrajozwi]

Hi all!

I am a new Power BI user. I have a huge problem with calculating rows from each column, where the slicer is from separate date table. 

Currently I have one table Candidates with the following columns (this is a view from SQL db):

1. PhoneScreenDate

2.RecruiterSubmittalDate

2. RecruiterRejectionDate

3.RecruiterAcceptanceDate

with the dates as a value. 

I would like to create a Slicer, (now it is filtered by RecruiterSubmitalDate), but we can have a situation where there were only some Phone Screens with 0 Recruiter Submitals, which will give me a chance to count all the columns. 

I was trying to create a separate Calendar Table and compare every column with that but it is not working. 

As a result I would like to have a table with the countrows of:

Phone Screens - one column

Recruiter Submitals - second column etc.

But it need to be a slicer with the date. 

Thank you all for all your support!

[v-chuncz-msft]

@aleksandrajozwi,

You may refer to the following post.

https://community.powerbi.com/t5/Desktop/Custom-slicer-that-toggles-between-columns-to-generate-a-ch...

[PattemManohar]

@aleksandrajozwi Please provide some sample data and expected output, to provide any solution

[aleksandrajozwi]

Hi!

The data source is SQL DB, but you will find a sample of my data below:

https://imgur.com/ng3Eux9

When it somes to the expected result, I need a table with the separate columns as: Phone Screens, Submitted to Recruiter, Accepted by Recruiter, Rejected by Recruiter. 

What is the most important is the slicer with the date to choose only some period of time (we have to show the report for previous week mostly, but our client can choose any other date as well). 

Thank you very much!

aleksandrajozwi. 

[PattemManohar]

@aleksandrajozwi Could you please post some sample data and expected output, to provide any solution