Forum Discussion
Combo chart using population age data
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
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)
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)
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)
Thanks, I tried that just now, still seems to be displaying the same way... Maybe something to do with the fields section then?
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