Forum Discussion
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?
6 Replies
nirvana_mokshImpactful 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 https://docs.microsoft.com/en-us/powerquery-m/date-fromtextnirvana_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...
- nirvana_mokshAnonymous - 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.
v-yulgu-msftMicrosoft 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.
Regards,
Yuliana Gu