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

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.