Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I am trying to create a scatter graph of a continuous y variable (date) as the x-axis. As you can see below, the default scatters graph does not respect the difference between dates like the line graph does.
Scatter graph:
Exact same data using line graph and aggregation set to minimum value:
The line graph gets the correct result with the spacing of the dates, how can I do this for the scatter graph?
Solved! Go to Solution.
Hi @JFG123
Download sample PBIX file with the data and charts shown below
Dates are not continuous, they are discrete. You can only have fixed values for dates,they can't be half way between one date and another date.
Scatter charts plot the data you give them so you are seeing the discrete date values plotted on the x-axis.
If you are missing dates then these are omitted from the plot.
In this image the top visual has data for every date between the first and last dates, the bottom visual does not
regards
Phil
Proud to be a Super User!
Hi @JFG123
Download sample PBIX file with the data and charts shown below
Dates are not continuous, they are discrete. You can only have fixed values for dates,they can't be half way between one date and another date.
Scatter charts plot the data you give them so you are seeing the discrete date values plotted on the x-axis.
If you are missing dates then these are omitted from the plot.
In this image the top visual has data for every date between the first and last dates, the bottom visual does not
regards
Phil
Proud to be a Super User!
@JFG123 , Seems like scatter visual does not provide Axis type option - Continous. This option is there online not in scatter.
This because scatter we need show discrete values
User | Count |
---|---|
96 | |
87 | |
78 | |
72 | |
69 |
User | Count |
---|---|
113 | |
105 | |
84 | |
65 | |
64 |