Unable update visualisation affected by a Measure

Thankyou, burakkaragoz, danextian for your response.

Hi ksubi,

We appreciate your question on the Microsoft Fabric Community Forum.

As I understand, the issue happens because calculated columns are static. They only calculate when the data is refreshed and do not change when you use slicers or parameters like the Date Offset slider. That is why the visuals did not update dynamically when you moved the slider.

To fix this, we used a measure instead of a calculated column. The measure calculates the status dynamically. We also added the "Status per Adjusted Launch Date" measure in a Table visual. This way, the results update correctly when you move the slider.

Please find the attached screenshot and sample pbix file for your reference:

If you find our answer helpful, please mark it as the accepted solution. This will help other community members who have similar questions.

If you have more questions, feel free to reach out to the Microsoft Fabric community.

Thank you.