Constant line based on input

[Anonymous]

I have a line chart that i want to display a constant line on based on user input, so i added a what if parameter. the problem is that my minimum and maximum values change depending on the columns selected from a slicer. i made 2 measures, minimum and maximum values, which take the 'value' column from my Unpivoted table that i made to be able to choose between different columns. the minimum and maximum measures work perfectly how i want depending on the column i have selected, but they dont work in the what if parameter, the what if parameter has this query : 

Const Line =

GENERATESERIES(

    [Min_Ref_Line],

    [Max_Ref_Line],

    1

)
it is giving me the minimum and maximum of all my values in the Unpivoted table, not based on my slicer selection

[MFelix · Accepted solution]

Hi @Anonymous ,

You cannot make a table to be dependent on measures since measures are dependent on context, when you select the values from a slicer that value is not moved into the table since tables required a row context and in that case will pick up all the values from you original table instead of the values selected in the slicer.

What is the result you want to have on your constant? Can you give some more context?