cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Anonymous
Not applicable

## Which type of graph to use?

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.

2 ACCEPTED SOLUTIONS
Frequent Visitor

I think that a simple bar chart could help.

Resident Rockstar

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.

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

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 REPLIES 4
Resident Rockstar

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.

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

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

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 🙂

Frequent Visitor

I think that a simple bar chart could help.

Solution Sage

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.

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

Regards,

Affan