Forum Discussion

2NV_DB's avatar
2NV_DB
Frequent Visitor
2 years ago
Solved

Keep the filer context within a parameter

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

Need Help

3 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    2 years ago

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

     

    or try

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

    • 2NV_DB's avatar
      2NV_DB
      Frequent Visitor
      2 years ago

      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!