Bar Line Chart: Line Sum Issue

[erikzimm]

Hi, 

I am trying to make a bar and line combo chart. My bars work fine but when I add the line to the chart, the line sums all data into one flat line by summing all the data in the column. This is monthly data for both the line and bars, and it is connected via a date table. A snip of the data can be found here:

Table for Bars                                    Table for Line

Date          Col1       Col2                    Date           Col3

Jan 2022     1.5%      3.5%                  Jan 2022       7.0

Feb 2022     2.5%      1.5%                  Feb 2022      3.5

Mar 2022     2.0%      2.0%                 Mar 2022     4.0

As said the bars look fine, coming from the "Table for Bars" Col1 and Col2. The issue arises when I add Col3 into the line y-axis, it takes the sumation of Col3 and uses that for every month (in this case 14.5), rather showing me Col3 value month to month. The end result is a clustered bar chart, and a flat line across it, when it should be a bar chart with the value from Col3 at every given month as the line. Note that the Date field being used to produce the end chart comes from the Date table, which both data tables are connected to on their respective date fields. 

PS: clicking "Don't summarize" does not work. 

[Greg_Deckler · Accepted solution]

@erikzimm I can't replicate this. It certainly seems like a missing or broken relationship:

[erikzimm]

It was a relationship issue! Thanks! 

[sayaliredij]

Hi @erikzimm ,

PLease check i have tried almost the same and it has worked for me

LineBarChart.pbix 

Thanks and Regards,

Sayali

Please mark the question solved when done and consider giving a thumbs up if posts are helpful!! 

[Daniel29195]

@erikzimm 

could you please share the power bi file so i can take a closer look at what is the possible cause of your problem . 

best regards