Scatter Chart by date without summarisation

[Cheezeduckies]

I am trying to create a chart that shows the different tempereatures each day for a year, I am having two issues, the first is that the dates are not all fitting within the one page and I cannto find a way to remove the slider so they all sit on the page, the second more pressing issue is that I cannot seem to get the data to not appear aggregated, as when I try to remove summarisation an error occurs. Is it possible to do this in Power Bi? The image hows my current version with only one piecec of data for each date as well as the slider that I am hoping to remove, the sceond shows the issue when I remove aggregation, the final image is a replica from Tableau showing what I am hoping to achieve.

[Anonymous · Accepted solution]

Hi @Cheezeduckies 

1. When there are a large number of dates on the X-axis, the date labels may not be fully displayed, and a slider is required to view the full date range. Try using the Date Hierarchy to adjust the date display. Or use the slicer to reduce the date range. See page1 of my pbix file.

2. Instead of removing summarization directly, we can create a measure for the temperature and apply it to the scatter chart. See page2 of my pbix file.

_Temperature = SELECTEDVALUE('Table'[Temperature])

^{Best Regards,}

^{Jarvis Tang}

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