How to QUICKLY Shade Between 2 Lines in a Line Chart in Power BI
It can be hard to see the difference between 2 trend lines, and if close together even harder if you want to know which is higher or lower.
This is where shading between the lines can help and I’ll show how you can shade with lines, or fill the space, and also add dynamic colour change the lines or fill if higher or lower than each other.
#PowerBI #DAX #PBICoreVisuals
📁 Dataset for Sales Data and file for original dim date table M code
https://data.world/deanchereden/super...
🔖c h a p t e r s 🔖
00:00 - Intro
00:42 - Types of line chart fills
01:14 - Create line filled line charts
02:12 - Fix month name sort order
02:35 - Add error bar lines
04:19 - Add shading between lines
05:04 - Create a measure for high / low band
05:26 - Line colour based on if high or low
06:41 - Shade colour based on if high or low
💌 My email - [email protected]
🌍 My website - https://www.deanchereden.com
🐦 Twitter - / deanchereden
🎵 Blue Wednesday, Shopan - Déjà Vu https://chll.to/39fcf474
🎶 Listen to Chillhop Music - • Misha & Jussi Halme - Bliss (A Felicidade)...