Forum Discussion
Scatter chart problem
Hi Pamiko,
Thank you for reaching out to Microsoft Fabric Community Forum.
Power BI requires a DateTime column to enable a continuous X-axis in scatter charts. Using only month and year will treat the axis as categorical, so it won’t support hourly-level detail.
To visualize capacity usage by hour across the year, create a combined OrderDateTime column (date + hour), and use it on the X-axis. The Y-axis shows the total number of people per hour.
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Regards,
Vinay Pabbu
Hi Pamiko,
Thank you for reaching out to Microsoft Fabric Community Forum.
Power BI requires a DateTime column to enable a continuous X-axis in scatter charts. Using only month and year will treat the axis as categorical, so it won’t support hourly-level detail.
To visualize capacity usage by hour across the year, create a combined OrderDateTime column (date + hour), and use it on the X-axis. The Y-axis shows the total number of people per hour.
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Regards,
Vinay Pabbu