Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
Sanmaya1
Frequent Visitor

Need help in creating the chart attached

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

 

Screenshot 2024-05-24 134716.png

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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

Hi @Sanmaya1 ,

The Table data is shown below:

vzhouwenmsft_0-1716878086848.png

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

vzhouwenmsft_1-1716878172389.png

 

View solution in original post

4 REPLIES 4
Anonymous
Not applicable

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

Hi @Sanmaya1 ,

The Table data is shown below:

vzhouwenmsft_0-1716878086848.png

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

vzhouwenmsft_1-1716878172389.png

 

Sanmaya1
Frequent Visitor

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

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





Did I answer your question? Mark my post as a solution! Kudos are welcome.

Proud to be a Super User!




_AAndrade
Super User
Super User

Hi @Sanmaya1,


Could you describe in more detail your issue or needs?





Did I answer your question? Mark my post as a solution! Kudos are welcome.

Proud to be a Super User!




Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors