It's good to finally have this feature/flexibility! Another challenge is it possible to plot timeseries data (such as IoT sensor data) - say temperature vs time and there are some missing temperature values ... how do you plot it on a continuous line chart with a gap in the continuous line (for missing values) without joining the points with a straight line in between. Cannot put date-time on categorical line chart. Have struggled to do this also in Power BI.
Why wouldn't you put it in the secondary Y-Axis? I use that when I need to compare similar data that's on a different metric. Example would comparing Total $ Sales and maybe Pieces/Qty shipped. Usually if you put them on the same axis Qty can almost look like "0" if the $ value is super high
Great content as always, guys! One thing I noticed is that the example compares "Total sessions" to a "7 day average", and my kneejerk reaction would be to see the sessions data broken up by type, resulting in a stacked chart. I actually work with a similar setup where my data has to be a stacked chart and a 2nd line chart overlay (e.g. stacked department expenses vs total company budget). Any ideas on how to combine those two styles together into one chart?
So I just discovered the Error Bars trick in the last couple of weeks so to me having to create a Breakeven chart to show Green Shade for profit was higher than expense and Red for higher expense than profit from a month to month balance. Basically showing the difference in shade between two lines without all the underneath shading. My Resource to learn this was from @MITutorials from this video: ruclips.net/video/tJSmxJJJLK8/видео.html
![BRASIL vs. URUGUAY [1-1] | RESUMEN | ELIMINATORIAS SUDAMERICANAS | FECHA 12](http://i.ytimg.com/vi/-hWBAuxF1eY/mqdefault.jpg)
It's good to finally have this feature/flexibility!
Another challenge is it possible to plot timeseries data (such as IoT sensor data) - say temperature vs time and there are some missing temperature values ... how do you plot it on a continuous line chart with a gap in the continuous line (for missing values) without joining the points with a straight line in between. Cannot put date-time on categorical line chart. Have struggled to do this also in Power BI.
Why wouldn't you put it in the secondary Y-Axis? I use that when I need to compare similar data that's on a different metric. Example would comparing Total $ Sales and maybe Pieces/Qty shipped. Usually if you put them on the same axis Qty can almost look like "0" if the $ value is super high
300% agree
Yep, to much effort for a something you will expect to be out of the box
Great content as always, guys! One thing I noticed is that the example compares "Total sessions" to a "7 day average", and my kneejerk reaction would be to see the sessions data broken up by type, resulting in a stacked chart. I actually work with a similar setup where my data has to be a stacked chart and a 2nd line chart overlay (e.g. stacked department expenses vs total company budget). Any ideas on how to combine those two styles together into one chart?
Q: why are we not using excel for that?
So I just discovered the Error Bars trick in the last couple of weeks so to me having to create a Breakeven chart to show Green Shade for profit was higher than expense and Red for higher expense than profit from a month to month balance. Basically showing the difference in shade between two lines without all the underneath shading.
My Resource to learn this was from @MITutorials from this video: ruclips.net/video/tJSmxJJJLK8/видео.html
From INDIA
Hi
PowerBI still needs more native visual (all customs visual are terrible). I can’t believe excel still has more visual types than power bi.