Dynamic Y Axis Constant Line in Line chart (SSAS & PowerBI)

[syam562]

Hi All,

Please help.

Requirement:-

I want to add dynamic 'Y Axis constant line' in Line Chart visual using a dropdown list slicer. 

So the user can select the constant line every month from the list and line will appear in chart.

Work Done so far:

I have created calculated table in SSAS with GENERATESERIES()

Issue:- 

I am using SSAS as my datasource - live connection.

Howerver, when the conditional value format settings, i am always gettings summarization(Count,Sum,Avg etc)

But i need get the all parameter value.

"Field Value"
"What field should we base this on"

"Summarization"

Any help will be highly appreciated.

Thanks.

S

[amitchandak]

@syam562 , Create a measure using the series

measure = selectedvalue(Param[Value])

and use that in constant line fx option