Keep the filer context within a parameter

[2NV_DB]

Hi there,

I have a scatter chart where I would like to define a constant line on the X-Axis using a parameter slicer

I would like to make the max value of the parameter equal to the maximum value of the X-Axis. If I do this simply by saying MAX(Column_XAxis), I lose the context of the filters applied to the chart.

How do I keep my Max value based on the filters applied to the chart?

Thank you

[amitchandak]

@2NV_DB , That should work if you use constant line using fx option

or try

maxx(allselected(Table), Table[Value])

[2NV_DB · Accepted solution]

I used this as my solution if anyone looks at this in future.

https://www.youtube.com/watch?v=AZAL-QPn5Zc

[2NV_DB]

Hi @amitchandak ,

I am changing the position of the constant line based on the slicer. For example, if my x axis is sales, and I do Max(Sales[Netsales]) I would get 1,500,000. However, on my chart I have selected various filters such that the displayed data has a maximum of 300,000. As such, I would the largest value I can select on my slicer to be 300,000, and not 1,500,000. This should change dynamically based on the filters selected.

I hope this is clearer. 
Thank you!