Forum Discussion

UmairKhankhail's avatar
UmairKhankhail
Frequent Visitor
3 years ago

Using Date Range Slicer in measure.

Hi All!

 

I am new to powerbi community. I am searching it since last month and found 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!

Need Help

5 Replies

    • UmairKhankhail's avatar
      UmairKhankhail
      Frequent Visitor
      3 years ago

      Actually when I use  measures: joiners,leavers,joiners & leavers and continue, in the field parameter. The slicer build through field parameter does not affect the charts on the report.

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        Hi UmairKhankhail ，

        I'm not clear about your requirement. Do you want to get the count of active employees during selected date period? Or you want to create a calculated column with the values(continue,leavers,joiners and leavers & joiners) and put it on the bar chart as legend? Could you please provide some raw data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

        How to upload PBI in Community

        Best Regards