Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Combo chart using population age data

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...
Need Help
  • HotChilli's avatar
    HotChilli
    7 years ago

    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

HotChilli's avatar
HotChilli
Community Champion
7 years ago

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's avatar
Anonymous
Not applicable
7 years ago

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

  • HotChilli's avatar
    HotChilli
    Community Champion
    7 years ago

    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's avatar
      Anonymous
      Not applicable
      7 years ago

      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.