Forum Discussion
Using Date Range Slicer in measure.
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
Hi UmairKhankhail ,
The value of a calculated column is computed during data refresh and uses the current row as a context, it will not change according to the user interaction(slicer, filter, column selections etc.) in the report. So it can't achieve your requirement(change the column value(continue,leavers,joiners and leavers & joiners) base on slicer selections) by creating a calculated column. Please review the following links about the difference of calculated column and measure...
Calculated Columns and Measures in DAX
Calculated Columns vs Measures
We can consider creating a measure and put this new measure onto the Tooltips option. Could you please provide the conditions of how to get these values(continue,leavers,joiners and leavers & joiners)? For example: Continue, when it can be set as Continue? Thank you.
Best Regards