Forum Discussion
Using Date Range Slicer in measure.
Super UserUmairKhankhail , Please HR blog and measures, if those can help
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.
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
Yes, exactly I want calculated column with the values(continue,leavers,joiners and leavers & joiners) so that I could put it on the bar chart as legend. But I think we can not use dynamic dates coming from slicer in the calculated column (becuase when we change date range in sclier the values of continue,leavers,joiners and leavers & joiners should also change), so we will have to use measure instead of column i think.... if we had a way to use it in a calculated column then it would be much better.
The sample data and .pbix file is as follows:
https://drive.google.com/drive/folders/1jFczcMPTL1TUmAtTJW-YFz3m5_v4zWg9?usp=sharing
