Forum Discussion

syam562's avatar
syam562
New Member
3 years ago

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

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

1 Reply

  • syam562 , Create a measure using the series

     

    measure = selectedvalue(Param[Value])

     

    and use that in constant line fx option