Scatter Plot with date axis

[auxilio99357]

Hii everyone!

I'm trying to make an scatter plot with the number of the day of the month vs the number of sales transactions.

This is my dimdates chart:

And the number of transactions measure:

Total Transcactions = DISTINCTCOUNT(Sales[GF_Sales_Num])

I read some similar posts and i learned that Power BI plots your data against 2 measures and that is no way for a scatter chart to use an attribute like "date", but  maybe you can come up with something!

Hoipe you can help

Tksss

[v-henryk-mstf]

Hi @auxilio99357 ,

Here is a similar solution, whether it can help you.

If there are still problems, can you further describe your needs, it is best to provide screenshots and test data of the expected results, I will answer you as soon as possible.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak · Accepted solution]

@auxilio99357 , on axis can be categorical (like date) , but you need details column is scatter plot.

Example of categorical axis

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-scatter#dot-plot-charts