Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Reply
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
danielpenafiel
Frequent Visitor

I think that a simple bar chart could help.

 

 

Capturaddd.JPG

View solution in original post

v-piga-msft
Resident Rockstar
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.


 

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.

Capture.PNG

 

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.

View solution in original post

4 REPLIES 4
v-piga-msft
Resident Rockstar
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.


 

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.

Capture.PNG

 

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 🙂

 

Screen Shot 2019-01-09 at 12.58.47 PM.png

danielpenafiel
Frequent Visitor

I think that a simple bar chart could help.

 

 

Capturaddd.JPG

affan
Solution Sage
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.

 

Please see the report here.

 

 

 

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

 

Regards,

Affan

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.