Forum Discussion
Alternatives to Native Line chart?
cyclist007 , For the first one. If you change axis type to categorical, that should work. 2nd and 3rd are not clear to me
For #2 Would like to have combination of below two charts:
(also as you can see below there are no readings on sept 26th & 27th , so the lines join across from sept 25th to sept 28th)
With lower limit & upper limit:
Any other alternative to better represent/display time based data on a continuous line chart (without joining lines and avoiding misrepresention)?
Hi, cyclist007
Maybe you can copy the date ,then try to change the new column "Text_date" type from "Date" to "Text".
If the axis sorting is not accurate, you may need to create an index column in query editor and make the new column"Text_date" sort by this index column.
You can check if the attached pbix file is helpful.
Best Regards,
Community Support Team _ Easonv-easonf-msft Thanks for taking the time in creating an example to showcase. But on reviewing it I found that it converts the axis to a categorical axis when the x-axis field is a text field, which does not work well with date-time fields (especially at minute intervals) and also results in misleading gap periods. See below how it ends up looking in below screenshot ... text field/categorical axis does not provide the solution in this case (the huge scroll bar just does not allow for a single view analysis for different lengths of time that the continuous axis allowed for).
