cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
byronkelly
New Member

line chart

I am trying to plot a basic line chart, where I can compare 3 lines (volume X Year) . When i plot each line individually, the line plots correctly. However when i plot all three lines on a single plot, the number for 2 of the 3 lines are wrong.

 

For example, line 1, 2 and 3 each have values from 0-1000, with line 1 generally larger than line 2, and line 2 larger than line 3.

 

When i plot them all on a single plot, line 1 retains its original values but the values of line 2 and 3  change to a constant 217,930 for all years.

 

Any help would be appreciated. Sorry i can not include an image.

1 REPLY 1
Super User III
Super User III

Re: line chart

Hi @byronkelly,

 

Can you share some more insight on what you are making?

 

  • Are you using measures or values from a column? 
  • Are all the values from the same table?
  • Do you have an X-axis that is common?

 

Based on your explanation I'm assuming that you are using information for X-Axis from the same table for line 1 and the other 2 lines are from another table or tables without a relationship to the 1st one.

 

If this is what is happening the result you are getting is the line 1 correct since it's related with the values on X-Axis, and the other two lines are calculated based on it's total number of data points (count or a sum) for the full table where they.

You are getting a constant since the line chart can't determine the context for line 2 and 3 so it return the full sum of those values.

 

To overcome this you need to have a relationship between the tables you are using in that way when you use a column on the X-Axis all of the value place in the chart will be related and summarized accordingly.

 

I know this is a little bit theorical but without any additional information is difficult to give you a better answer.

 

In attach is a PBIX file with 5 tables:

  • 2 table with no relation and place on the same chart, as you can see you have 1 line that is a constant
  • 2 tables related by a Dimension table (category) that is used for the 2nd chart and giving the correct values.

relation.png

 

Believe this is your issue, but if not please tell me more specifications on your data model so I can help you.

 

Regards,

MFelix


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Check out my blog: Power BI em Português


Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors