Unable update visualisation affected by a Measure

[ksubi]

I got two tables: Product Arrival Date and Launch Date (see attached files).

Link to Product Arrival Data. 

Link to Launch Date  

Link to Power BI file 

If 'Product Arrival Date'[Arrival Date] <= [Adjusted Launch Date]  then the output should be "On Track". Otherwise the output is "Past Launch Date".

Adjusted Launch Date is a measure defined as follows:

Adjusted Launch Date = MAX('Launch Date'[Launch Date]) + 'Date Offset'[Date Offset Value]

where 'Date Offset'[Date Offset Value] is parameter whose value is determined by slider.

Problem: As per the pie chart image below we can see that 'Product Arrival Date'[Arrival Date] > [Adjusted Launch Date]. Therefore the data in the pie chart should be labelled as "Past Launch Date". But it labelled by Power BI as "On Track"

What I have tried: I have know calculated columns are not dynamic however tried see if refresh could update the visuals when I set the 'Date Offset'[Date Offset Value] to the value I am interested in. 

The relationships of the tables is shown below:

[v-pnaroju-msft]

Hi ksubi,

We are checking in to know if the information we provided helped in resolving your issue.
If you have any further questions, please do not hesitate to contact the Microsoft Fabric community.

Thank you.

[Natalie_iTalent]

Dear community members,

A response that was unrelated to the original topic has been removed from this thread.  We wanted to add this clarification as there are additional comments related to that comment shown.

Please feel free to reach out to me if you have any questions.  

Best,

Natalie H.

Community Manager

[v-pnaroju-msft · Accepted solution]

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.

[danextian]

Your sample data is confusing. Why the need to create a relationship between Launch Date and Arrival Date columns when they don't have a match?  - launch dates are all july while arrival dates are june.

[danextian]

Hi @ksubi  

Did you mention databricks in your initial post?

@burakkaragoz 

I don’t see any mention of Databricks in the post, so I’m not sure why it was included in your reply or why OP would need to re-authenticate to it.

[ksubi]

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.

[burakkaragoz]

@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.