Forum Discussion
Line chart only shows missing data gaps when adding multiple x-axis inputs
Becuase the IoT sensor data is coming in at slighly varying times, once in a while a time slot is skipped, creating gaps when combining sensor data in the chart. No actual data points are missing, they are just not being "assigned" to every incremental time slot on my Time table. See picture 3 - raw sensor data, and picture 4 - PBI chart export data.
Is there a way to enable graph lines to coninute point to point through any "missing" data as shown in picture 1?
Picture 1 has the time slot 8:40, is missing time slot 8:50, and has time slot 9:00. Using just one sensor data line, the chart line displays as desired. Adding one or more sensors to the chart causes "gaps" to show. Please see the picture 2, which shows adding more sensors, and the time slot 8:50 gap is no longer connected.
Picture 1Picture 2Picture 3 - Sensor dataPicture 4 - PCI report export
4 Replies
JHarmon , go to x-axis setting of the visual in format setting and change the type to "Categorical".
I'm not seeing "Type" or "Categorical" option. Am I looking in the right location?
Actually....after digging more, when I drill up and only have "Date" on the X-Axis, I can change to "Categorical", but when I drill back down and have Minutes, Dates, "Categorical" is no longer an option, nor applies. Is there a solution in this case?
