Bubble Chart with Date on y-axis and contract name to be on the bubble instead of legend

[tdinh]

I want to create a bubble chart with each bubble respresent 1 contract with x-axis is contract value, y-axis is contract date, the size is number of employee. I run into issue that I can't make contract date to be in y-axis and the contract name does not show on the bubble (I have to make it as legends but ideally I just want them to show the name with 1 color only).

[Anonymous · Accepted solution]

Hi @tdinh ,

Based on my testing, it is impossible to drag the date column directly into the Y-axis.

please try the following methods as workaround:

1.Create the simple table.

2.Create the new column to calculate the date week.

week number = WEEKNUM('Table'[Date], 2)

3.Drag the column into the scatter chart.

4.The result is shown below.

5.You can move the mouse over the bubble to display the contract name.

Best Regards,

Wisdom Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.