How to create Legend column from 2 Measures in Scatter Plot

[Anonymous]

Hello Power BI Expert,

I want to ask how to create a Legend for Scatter Plot to spot 2 highlight dots as the attached photo. This chart is about Profitability & I want to spot the 1st dot that first reach 100% profit & the 2nd dot that starting decreasing from the curve.

I have 2 measures as X & Y axis that makes the case more complicated.

Thank you for your time & consideration.

[v-shex-msft]

Hi @Anonymous,

Current power bi not support to create dynamic calculated column based on dynamic measure which based on slicers/filters.

Measure result will been fixed as static value when you use it in calculated column.

Reference link:

Calculated Column/Table Change Dynamically According to Slicer Selection in the Report.

Regards,

Xiaoxin Sheng