Forum Discussion

tubn's avatar
tubn
Regular Visitor
10 years ago
Solved

Date items in bubble chart axis

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 ite...
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    10 years ago

    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

Rudnaz's avatar
Rudnaz
New Member
1 year ago

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