Forum Discussion
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.
Hi burakkaragoz
The visualisations were never working. I am only using Power BI and am not using any other tool such as Databricks.
I have not made any changes to the tables. I have also tried refreshing the data but that has not work.
ksubi ,
Thanks for the clarification — that helps a lot.
Since you're only using Power BI and the visuals never worked from the start, the issue is likely related to how the measure is being evaluated in the visual context.
Measures like your Adjusted Launch Date are not evaluated row by row — they’re calculated once per filter context (like per slice in a pie chart). So when you compare a column (Arrival Date) to a measure (Adjusted Launch Date), Power BI doesn’t do a row-level comparison. That’s why the logic seems off.
To fix this, you might want to move the logic into a calculated column instead. That way, the comparison happens per row and reflects the slicer value correctly.
Here’s a rough idea:
Adjusted Launch Date Column = CALCULATE( MAX('Launch Date'[Launch Date]) + SELECTEDVALUE('Date Offset'[Date Offset Value]), ALLEXCEPT('Launch Date', 'Launch Date'[ProductID]) // or your key column ) Status = IF( 'Product Arrival Date'[Arrival Date] <= 'Product Arrival Date'[Adjusted Launch Date Column], "On Track", "Past Launch Date" )This response was supported by AI for translation and text editing.
