Forum Discussion

Sanmaya1's avatar
Sanmaya1
Frequent Visitor
2 years ago
Solved

Need help in creating the chart attached

Hi , i need help or idea to create a chart attached.

 

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi _AAndrade ,thanks for the quick reply, I'll add further.

    Hi Sanmaya1 ,

    The Table data is shown below:

    Please follow these steps:
    1. Use the following DAX expression to create a table

    Table 2 = GENERATESERIES(0,2000,500)

    2.Use the following DAX expression to create a measure

    Measure = 
VAR _a = SELECTEDVALUE('Table 2'[Value])
VAR _b = DIVIDE(SUM('Table'[Cost]),SUM('Table'[Kgs]),0)
RETURN _b * _a

    3.Final ouput

     

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi _AAndrade ,thanks for the quick reply, I'll add further.

    Hi Sanmaya1 ,

    The Table data is shown below:

    Please follow these steps:
    1. Use the following DAX expression to create a table

    Table 2 = GENERATESERIES(0,2000,500)

    2.Use the following DAX expression to create a measure

    Measure = 
VAR _a = SELECTEDVALUE('Table 2'[Value])
VAR _b = DIVIDE(SUM('Table'[Cost]),SUM('Table'[Kgs]),0)
RETURN _b * _a

    3.Final ouput

     

  • Sanmaya1's avatar
    Sanmaya1
    Frequent Visitor
    2 years ago

    the x axis has Kgs value and the y axis has cost .. the lines are showing th cost by KG per services.

    • _AAndrade's avatar
      _AAndrade
      Icon for Resident Rockstar rankResident Rockstar
      2 years ago

      Could you please share some data so I could try to understand your need?