Combo chart using population age data

[Anonymous]

Hi All,
I am new to Power Bi and I am really struggling to create a combo chart... I basically want to create a chart that shows the age profile for one group, compared with the age profile of another group (using percentages for each age category, not numbers so that they can directly compare). I created two separate tables (one for both groups) in excel with their respective percentages, and have added this to power Bi. When I try and create a combo chart, one data series seems to plot fine as the column chart, but when I try and add the comparison line using the second groups percentage data, it just displays one continuous line, and doesnt show the variation in the data... I am sooo confused and would really really appreciate the help! Like I say I am new to the software, so please tell me where I am going wrong!  

[HotChilli]

This will either be a relationship issue (are the two tables linked?) or a summarization problem (the percentage is being summarized when it shouldn't be)

[Anonymous]

The two tables are not linked through relationship but I did try this and it didnt resolve the issue, unless I made the wrong type of relationship (1-1)? 

I think you might be right about the summarization - how would I go about resolving this? 

It might be that need to import the excel data differently, or i might have formatted it incorrectly? Below are two screen shots of how the data looks in the data viewer tab. One data set is named 'hampshire age' the other is named 'insight age'. Both are different populations, with their age percentage breakdown (both exactly the same format)

---

[HotChilli]

Look for the 'default summarization' on the Modelling tab.  I can see that the 2 percent fields are set to 'SUM' but you want 'Do not summarize' on both those fields because you want to show individual values (not add them up)

[Anonymous]

Thanks, I tried that just now, still seems to be displaying the same way... Maybe something to do with the fields section then? 

[HotChilli · Accepted solution]

You don't want 'count' of percentage in that field well.  Put SUM there.
You must set the relationship up properly.

When you're at the beginning of your powerbi journey there is a steep learning curve.  I encourage you to go through the microsoft tutorials

[Anonymous]

Ok great thank you - I have set the relationship up now and using 'sum' in the field boxes and seems to be working! 

Thanks very much for your help! And yes I will definitely look through the microsoft tutorials.