Forum Discussion
PivotChart (line plot): date in x-axis not continuously and evenly distributed
Hi All: I would like to use the timeslicer to link multiple pivot charts. However, I found Excel's line plot will make the date in the x-axis not evenly distributed evenly. The gap when the machine ...
Unfortunately, this is a (rather irritating) limitation of pivot charts with a date axis - it plots the values from the pivot field "as is".
(You may have noted that it is not possible to create an XY Scatter chart from a pivot table, so that is not a solution either).
Workaround: create your own (non-pivot) source table, using for example SUMIF/SUMIFS/COUNTIF/COUNTIFS formulas.
I am curious why Power BI is able to trick line plots similar to xy scatter plots. thank you