Forum Discussion

Pamiko's avatar
Pamiko
Regular Visitor
1 year ago
Solved

Scatter chart problem

Hi All,   I am currently trying to do a scatter chart for a PowerBI challange and I am stucked. I would like to show something very similar, where a pizzeria's capacity usage is shown: Ther...
  • Anonymous's avatar
    Anonymous
    1 year ago

    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