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
amitchandak ... thanks for the response #1 The categorical axis does not help or is rather worse due to long scroll bar and not equi-distant reading timestamps. #2 - Would have liked to add a lower limit & upper limit line based on device category. But the native line chart does not allow additional fields in value or secondary axis if you populate a legend (possibly due to color assingment conflicts). Also the constant line in analytics would not be dynamic (based on category). So was wondering if anyone else has managed to address this in some other way or using some other custom visual.
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 _ Eason
