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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

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
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors