Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
7 months ago
Solved

Scatter chart.

I'm having trouble with the scatter chart. I need to generate a scatter chart with a continuous axis, the problem is with the x-axis since I need the date to be shown and being continuous it shows me...
  • V-yubandi-msft's avatar
    V-yubandi-msft
    7 months ago

    Hi Syndicate_Admin ,

    You won’t be able to build this chart using a Scatter visual, because the Scatter chart requires a numeric X-axis and doesn’t support a continuous Date axis.

    To reproduce the chart you shared (dots over time with a horizontal threshold line), the recommended approach is to use a Line chart with markers enabled and the line hidden. This keeps the Date axis continuous and gives the same visual effect as a scatter plot.

     

    So the Scatter visual isn’t required the Line chart with markers is the supported way to achieve this in Power BI.

    FYI:

     

    I’ve attached a sample PBIX file for reference.


    Please take a look and let me know if you’d like any adjustments.