Build a line chart based on measures

[Anonymous]

Hello,

I have built a few measures for the future sales. These measures need user inputs so have to be built separately: Sales_2021, sales_2022, sales_2023.

Now I would like to draw a line chart and this line chart can change when user inputs different numbers: X-axis would be year, y-axis would be sales.

Would you please help?

Thank you!!

[vanessafvg]

can you provide some dummy data?

[Anonymous]

for example,

I have three created table:

Table 1:

parmeter: sales_2021_input - input from 1-1000

measure: sales_2021_value = SELECTEDVALUE(sales_2021_input)

Similar for Table 2 and 3 but the variable names are 2022, 2023.

Now I want to build a line chart with x-axis as year, y -axis as the sales_2021_value, sales_2022_value, sales_2023_value