Forum Discussion

erikzimm's avatar
erikzimm
Regular Visitor
2 years ago
Solved

Bar Line Chart: Line Sum Issue

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. 

4 Replies

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

     

     

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion

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

     

    • erikzimm's avatar
      erikzimm
      Regular Visitor

      It was a relationship issue! Thanks! 

  • Daniel29195's avatar
    Daniel29195
    Icon for Community Champion rankCommunity Champion

    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