How I can use slicer value in calculated column in power bi to calculate and show data automatically in a table when the slicer value changed?
I need to use the selected slicer value in a calculated column to calculate the elapsed days in my table based on the selected date from slicer.
I have used power bi measure based on slicer to get the value from a measure then I used this measure in the caulated column but the calculated column in table is not changed when I change the date in slicer!
First of all, you should be aware of the Calculated Column has more impact on the Memory than the measure, also it will not be recalculated until the data model is refreshed.
So, you should use a measure instead of the calculated column if you would like to change the calculation in a table when the slicer value changed.
To pass slicer value in a table and calculate the value when the slicer value changed you should do the following:
Steps
In your case, you Create a new measure to calculate the date difference between the date slicer value and the date field in your table as below:
elapsed duration based on slicer = DATEDIFF(FIRSTDATE('Tasks'[Start]),'Calendar'[Slicer Selection],DAY)
Output
Note: you should use FIRSTDATE() function to calculated the elapsed value per each row.
1.1k questions
678 answers
456 comments
193k users
Related Activities
Categories
Most popular tags