Reference line that changes based on what dimension is chosen

[phiilip]

Hello all,

so I have a chart with three alternative dimensions (Year/Month/Week), where I want to have a reference line that changes based on what dimension is currently active in the chart. For year i want to show 10 000, for month 800 and for week 200.

How do I go about this?

[SRA]

Hi,

Not sure this is possible when using alternative dimensions. It would be easier if you use an variable dimension with : pick(match(YourVariable, 'Year', 'Month', 'Week'), Year,Month, Week). You could used the pick line formula : pick(match(YourVariable, 'Year', 'Month', 'Week'), 1000 , 800, 200)

Let me know if you need more precise description. And if this answer is fittting your requirement, you can tick it as a solution. 

Regards

SRA