cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
VermontSC
Frequent Visitor

Bubble Chart Colours

I'm trying to get a bubble chart that tracks the number of students getting certain scores over time. I can get the chart moving correctly by using a calculated Details field which includes the Subject, Year Level, And above/below the expected score.

 

However, this also means that each bubble has it's own score as each bubble has a unique Details field.  Putting the Subject on the Legend gives me a legend that is correct, but doesn't help with the bubble colours. Putting the subject under details makes it unable to display.

 

I have the Score on the Y axis, Year Level on teh X axis, and Calendar Year on the Play axis.

 

What I'd like to do is have each Subject as it's own colour.  Trying all the variations I can find either results in incorrect movement, summation/average of scores, or a view that can't be displayed.

 

Any ideas?

 

2 REPLIES 2
Microsoft
Microsoft

Re: Bubble Chart Colours

@VermontSC,

 

I have tested it on my local environment, when adding [Subject] field to Legend, each subject has a different color.

Capture.PNG

So in your scenario, could you please provide us some screenshots about your report, if possible provide us your PBIX file, so that we can make further analysis.

 

Regards,

Charlie Liao

VermontSC
Frequent Visitor

Re: Bubble Chart Colours

Hi,

The problem is not with getting individual colours for subjects, but that all dots for that subject don't appear the same colour. You can see in the samples below that EVERY dot is a differnt colour and the legend is by and large ignored.

 

1.png2.png

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

April 2020 Community Highlights

April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

Top Solution Authors
Top Kudoed Authors