Forum Discussion

VermontSC's avatar
VermontSC
Frequent Visitor
8 years ago

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?

 

Need Help
Tips and Tricks
Tutorial Requests

2 Replies

  • v-caliao-msft's avatar
    v-caliao-msft
    Microsoft Employee
    8 years ago

    VermontSC,

     

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

    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's avatar
      VermontSC
      Frequent Visitor
      8 years ago

      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.