Forum Discussion
syam562
3 years agoNew Member
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
- amitchandak
Super User
syam562 , Create a measure using the series
measure = selectedvalue(Param[Value])
and use that in constant line fx option