Dynamic Reference Line on Y Axis

[Anonymous]

Hey, its very very urgent.

I need to have a simple reference line (horizontal) on my line chart. I've searched the net. No answer seems good. I have a measure which can change based on filters.

Please help ASAP !!!

[amitchandak]

@Anonymous ,

You can have a measure with a static value

M1 = 10

Measure with Avg.min/max value overall

M2 = calculate(Average(Table[Col]),all(Table))

Or use analytics Pane.

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970

[mahoneypat]

Please see this link for instructions on the Analytics pane.

https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-analytics-pane#:~:text=With%20the%...

You can also just create a Measure that has a constant value and add it also to your visual

ConstantLine = 10  (for example)

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat