Which type of graph to use?

[Anonymous]

Hi all,

I'm stuck trying to figure out what type of graph to use. I have age and about 10 different categories. I want to show how often that category shows depending on age. The data looks like this:

Age : Category

  10 | red

  11 | green

  11 | green

  11 | yellow

  14 | blue

I want a graph where someone can see that 11 year olds chose green twice and yellow once but I don't know how to do that. Right now I'm thinking of a bubble chart but I don't really know how to make that work either.

[danielpenafiel · Accepted solution]

I think that a simple bar chart could help.

[v-piga-msft · Accepted solution]

Hi @Anonymous,

---

 I want a graph where someone can see that 11 year olds chose green twice and yellow once but I don't know how to do that. Right now I'm thinking of a bubble chart but I don't really know how to make that work either.

---

For your scnario, the suggestion of danielpenafiel should be helpful.

If you want to use bubble chart, you could create the measure like below.

Measure = CALCULATE(COUNT(Table1[Age]),ALLEXCEPT(Table1,Table1[Category]))

Then create the bubble chart like this.

You also could have a reference of my test pbix.

Best  Regards,

Cherry

[Anonymous]

I'm assuming you're treating age as a continuous variable and not categorical? If that's the case, I'd suggest a stacked area chart. You'll be able to see its trend vs age more clearly and you can modify the area colors according to the color stated in your category to make your chart more intuitive 🙂

[danielpenafiel · Accepted solution]

I think that a simple bar chart could help.

[affan]

Hi @Anonymous

There is a power bi report shared by @cfunk on community Data Stories which can help you selecting the best chart for your data.

Please see the report here.

If this helped you, please mark this post as an accepted solution and like to give KUDOS .

Regards,

Affan