cancel
Showing results for
Did you mean:
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.

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.

Regards,

MFelix

Regards

Miguel Félix

Proud to be a Datanaut!

Check out my blog: Power BI em Português

Announcements

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

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

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

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

Top Solution Authors
Top Kudoed Authors