How to use Error bars in line chart with measures in field parameters slicer

[WulffJoergen]

Hi User Group

I have a line chart that shows either Total profit or Total revenue depending on what I choose in a field parameter.

I would like to create an error bar, where my Upper Bound shows the difference to last years Total Profit or last years total revenue.

So Y axis is either Total Profit or Total Revenue and X axis is the month this year.

I tried to let Chat GPT suggest a solution and was given this choice:

DynamicErrorMeasure =
SWITCH(
TRUE(),
SELECTEDVALUE(Parameters[Parameter]) = "Measure1", [Measure1_Error],
SELECTEDVALUE(Parameters[Parameter]) = "Measure2", [Measure2_Error],
BLANK()
)

But as soon as I put it in my visual creates an error and I do not get the possibility to undo, what I just did.

Can anybody help me with a solution that can generate a workaround for this?

I have created below graf with a hidden line ( 0 ppt) for the PY line. If that was visible, it would look like the second picture

   

regards
Jørgen

[WulffJoergen · Accepted solution]

Actually this was easier, than I thought.

Switch the Y axis to a measure that is dependent on the parameter instead of using the parameter value itself. Now you can create the error bar without any problem.