Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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).
Solved! Go to 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.
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.
User | Count |
---|---|
96 | |
86 | |
78 | |
72 | |
67 |
User | Count |
---|---|
110 | |
104 | |
84 | |
65 | |
63 |