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.

[PavanLalwani]

In Power BI, when you add a date field to the X-axis of a chart, it may automatically aggregate to "Count of Date" or some other aggregation, depending on how Power BI interprets the field. Here’s how you can display the dates as a continuous axis (time series) rather than as a count in a bubble chart:

 Steps to Use Date as a Continuous Axis

1. Convert the Date Field to Continuous:

   - In the Fields pane, select your Date field.

   - Drag the Date field to the X-axis of the bubble chart.

   - Click on the dropdown arrow next to the Date field in the X Axis area in the Visualizations pane.

   - Choose Date (instead of Count of Date) or select Do Not Summarize if that option is available.

1. Set Date Axis to Continuous:

   - In the Visualizations pane, go to the Format Your Visual tab (paint roller icon).

   - Under X-Axis, set the Type to Continuous instead of Categorical. This allows the dates to display along the axis in a continuous flow rather than as grouped categories.

1. Ensure Proper Data Formatting:

   - Make sure your Date field is recognized as a Date/Time data type. You can check this in the Data View. If it’s not recognized as a date, Power BI may default to treating it as a category, leading to aggregation.

1. Adjust Bubble Size (if needed):

   - You may also need to configure the Size field to represent the variable you want the bubble size to reflect. In your example, you’ve set Number to the size field, but verify that this is giving you the desired visual effect for your time series.

These changes should allow the date to display along the X-axis as a time series without aggregating into a count. This setup will help you see the changes over time rather than counts.

If this solution brightened your path or made things easier, please consider giving kudos. Your recognition not only uplifts those who helped but inspires others to keep contributing for the good of our community!

[Rudnaz]

Use a visual called "Line and BubbleChart" (Publisher: MSOffice ; Id: LineBubbleChart ; Version: 1.0.0.3)

It supports Date on the X axis without any need for digging into settings, reading guides or watching Youtube videos. Just drag and drop your data fields into "X Axis", "Y Axis", "Size" and "Legend".

As easy as it sounds.

This response is a bit too late to be useful for you, but it may help others who stumbled on propper date visualization on bubble charts

[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