Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
10 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
    10 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.

Tahreem24's avatar
Tahreem24
Icon for Super User rankSuper User
10 months ago

Syndicate_Admin Could you share the screen shot of the error? And it would be great to explain with sample example data (avoid sharing real and sensitive data) to better understand the issues.