Scatter Chart values not playing together nicely

Question

Hello,&nbsp;&nbsp;I'm trying to recreate the below scatter chart on PowerBI where each dot is a data point.&nbsp;Bu I've only managed to do the below so far, I have the correct X-axis (date) but the Y-axis shows a Sum of the data. To try and overcome this I've created an index column and put it on the Details.&nbsp;&nbsp;But when I select "Don't Summarize" the data on the Y-axis, then PBI says "Your x- and y-axis values aren't playing together nicely. Replace the x-axis field with a numerical value, or change the y-axis field values to summarizations". Any idea how can I overcome this?&nbsp;Thank you in advance,&nbsp;

amitchandak · Answer

Anonymous , I doubt do not summarize can help much. add an index column and add that as details 
https://stackoverflow.com/questions/45715963/creating-an-index-column-for-power-bi

anonymous · Answer

I've alredy added the index column as I mentionned on my message, but it's still summarizing the data on the Y-axis.&nbsp;

amitchandak · Answer

Anonymous , Can you share a sample pbix after removing sensitive data.

anonymous · Answer

amitchandak&nbsp;hi, how should I share?

anonymous · Answer

Hi&nbsp;amitchandak,&nbsp;&nbsp;I think I managed something but now I have another problem. The image below is what I'm trying to recreate on PBI: each point corresponds to a date (X-axis) either in 2019 or Q1 2020 and a length on the Y axis.&nbsp;However, on the PBI I've only achived the below: it onyl shows me three days of Q4 2019 and the Information button that appears tell me I have too many values and it's not showing all data. All in all, I have 1000 data points and I'd like to have them all displayed like the first picture, with the X-axis emcompassing the entire period selected but only displaying one reference date every couple of months.&nbsp;&nbsp;Any idea how can I achieve this on PBI?

Forum Discussion

Scatter Chart values not playing together nicely

5 Replies

Related content

Scatter Chart || your x- and y-axis aren't playing together nicely

Matrix & Slicer Not Playing Together

Scatter Chart

Scatter Chart won't let me add something to the Play Axis

scatter chart with Play axis question