Using Date Range Slicer in Measure.

[UmairKhankhail]

Hi All!

I am new to powerbi community. I am searching it since last month and fond it very userful. Hope, I get my problem solved. I am creating powerbi report for a payroll analyzer. These are my master and transaction data columns and data model.

Master Data:

Transaction Data:

Data Model:

I have created a report which is as follows:

In this above bar graphs, I want to have a legends of employees which continue, leavers,joiners and leavers & joiners with in a dynamic date range selected through the date slicer.

Now, Since we can not use slicer date within a calculated columns, so I want anyone could help me creating measures for employees which continue,leavers,joiners and leavers & joiners within in a dynamic date range selected through slicers... We have given employee starting and leaving date within date... The leaving date column could have blank value but the starting date would always be given.

Thanks!

[Anonymous]

Hi @UmairKhankhail ,

Not sure if I understand your idea.

Are you trying to create a date slicer to filter employee situations over different time ranges?Or do you mean something else?

By the way, the two images you have uploaded cannot be displayed:

Best regards,

Community Support Team Selina zhu

[UmairKhankhail]

@Anonymous 
Actually, I want to have legend in the bar graph of employees who joined, left, joined & left and continue.

The missing images are;

Data Model:

and,