Getting creative with a Line Chart in Power BI

Saw an interesting conversation about a line chart and some different approaches in Power BI. Adam explored those options and explains the differences. Never stop tinkering with visuals!

Twitter conversation:


*******************

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.


*******************
LET'S CONNECT!
*******************


***Gear***

#PowerBI #LineChart #GuyInACube

[mustafabiviji]

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.

[Lschick]

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

[Cicero_BC]

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?

[juanpablorvvv]

PowerBI still needs more native visual (all customs visual are terrible). I can’t believe excel still has more visual types than power bi.

[gamalabdelzaher]

Q: why are we not using excel for that?