Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Build a line chart based on measures

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!!

Need Help

2 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      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