Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Not applicable

Scatter Chart - Date as Number


Hi Guys,


I have a problem with Scatter Chart. I want to plot the time in days it took to complete an item in Azure DevOps with the date it completed on, as well as a percentile line for 85th/50th percentiles.


Currently I'm having to use the completed date as a number, which means my chart ends up looking like so:


When it should actually look like this:






Data is structured like so: 



Any tips on how I could potentially restructure the data to get it working?





Not applicable

That's not technically true, you can add date to the x-axis however it then sums the data points...





When you change it to 'don't summarize' you then get an error...




Microsoft Employee
Microsoft Employee

Hi @Anonymous,


Currently, it doesn't support to add date field onto axis of scatter chart. We can only place numeric fields onto axis, for both X-axis and Y-axis.



Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Impactful Individual
Impactful Individual

@Anonymous you can convert the last column in DAX using New-CompletedDateSK = Date(Left([Date],4),Right(left([Date],6),2),right([Date],2) You can refer to the below link for doing it in M
Not applicable

@nirvana_moksh I'm not sure how that solves my problem as I already have the CompletedDate column that has it in Date format? Apologies if I've misunderstood...

@Anonymous - Apologies for misunderstanding your question and replying with something else, what I would do is use the numerical date column (20180930) on the X-Axis and that should fix the issue. I think by design for the scatter plot, placement of a categorical field on X-Axis vs numerical value on Y-Axis will require some sort of aggregation on Y-Axis. To circumvent this convert your X-Axis to numerical as well (20180930) and then change Y-Axis to Do Not Summarize and it should work.
Not applicable

@nirvana_moksh that's what I already have in the 1st picture in my OP 🙂


Is there any way I could create bins to reduce the white space? Or a grouping to go 20181101-20181130 / 20181201 - 20181231 / 20190101 - 20190131 etc...

Helpful resources

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.