Forum Discussion
Alternatives to Native Line chart?
Hi,
I have tried using the native line chart but find several limitations. I am basically trying to plot temperature value (of various devices) against time (with readings as frequent as aevery other minute, but the plot would be for a week or multiple weeks).
Limitations which i notice in Power BI's line chart:
1. Can't have breaks/gaps in line - if I have no readings for weekends or weeknights it stills joins Friday's last reading to Monday's first reading ... would need to have breaks in lines when there is no reading - this is really misleading (and can't use zero as temperature value itself can be zero or negative)
2. Would like to have bands or at least constant lines (that can be change per category chosen). That is would like to show if the line/value is within an acceptable range or outside the range (the range would vary based on the device category chosen in the single select slicer). And I expect to plot multiple devices within the same (single chosen) device category.
3. If its stepped then allow for change in steps to be at the timestamp the change occurs not in between timestamps
Has anybody found and used any other line chart visual that can accomodate the above and all the native visual features? Or has a workaround for the above?
Want a line chart visual that does not required R.
Thanks
7 Replies
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)?
