Bubble Chart

Question

Hi,&nbsp;I am developing Power BI reports and I am trying to recreate the attached graph. The scatter chart doesn't work in my case as it doesn't allow to put in the x-axis a timeserie. Till now I manage to make something similar by using either the pulsechart or the spline chart but unfortunetely the first doesn't allow me to colour the bubbles according to the attribute "country" while the second doesn't allow me to give different sizes according to my measurement "post total reach".&nbsp;Please advice!&nbsp;

andyhoughton · Answer

I see. This should help:&nbsp;http://community.powerbi.com/t5/Desktop/Scatter-with-date-on-X-and-time-on-Y/m-p/19030

andyhoughton · Answer

Does putting Country field into the "Legend" section of the scatter graph not colour by Country automatically?

elenirapti8 · Answer

Yes it does but the problem with the scatter plot is that it doesn't allow to put dates on the x-axis

elenirapti8 · Answer

Thank you very much!! That was really helpfull! I manage to make this by creating a new measure with the value of minimum date:&nbsp;&nbsp;my only problem now is that I wish I could have date format instead of number format which unfortunately I cannot fix it from the Modelling tab.&nbsp;Any ideas??&nbsp;

v-ljerr-msft · Answer

Hi&nbsp;elenirapti8,&nbsp;As only aggregated data(value is usually a number) is supported for Axis in Scatter Charts, it is not possible to&nbsp;format the X Axis to date currently. You can vote the similar idea here.:smileyhappy:&nbsp;Regards

Forum Discussion

Bubble Chart

5 Replies

Related content

Bubble Chart With Categories

bubble chart

SVG Bubble Charts

Conditional Quadrants in Bubble Chart-PBI

Scatter Chart Bubble Size