Date items in bubble chart axis

[tubn]

Hi,

I'm new to Power BI Desktop and having trouble with bubble chart.

I'd like to set date items to x axis and see time series changing in bubble chart.

But when I drag and drop the date item to x axis, it's aggregated (counted number of the items is displayed) and gathered.

Can I avoid that?

I just want date items in x axis, not count of them.

[v-qiuyu-msft · Accepted solution]

Hi @tubn,

Both X-axis and Y-axis in the scatter chart is used for displaying numerical data. So it's expected the date field will be aggregated when you place it in axis. I would suggest you go through this tutorial to understand the scatter chart better: Tutorial: scatter charts and bubble charts in Power BI.

In your scenario, if you want to display date values without aggregated in X-axis, you can choose another charts, like column chart, bar chart and line chart.

If you have any question, please feel free to ask.

Best Regards,
Qiuyun Yu

[tubn]

Hi Qiuyun,

Thank you for replying to me.

I will try another chart which is suitable for time series data.

Thanks,

tubn