Don't miss your chance to take the Fabric Data Engineer (DP-600) exam for FREE! Find out how by attending the DP-600 session on April 23rd (pacific time), live or on-demand.
Learn moreNext up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. Register now
Your file has been submitted successfully. We’re processing it now - please check back in a few minutes to view your report.
06-26-2025 15:23 PM - last edited 02-01-2026 17:00 PM
As comparative visual creatures we are always judging, always comparing. Hence, our brains can be assisted by enhancing the color encodings of two items of interests on a typical line visualization, accompanied by the min and max boundaries to effectively, compare and contrast how the data values of these item varied against each other, across time and, versus the peers' average...all three comparisons, at-a-glance, with the band chart.
For a copy of the pbix file, feel free to message me at LinkedIn
eyJrIjoiNDNiZjc4YTAtMjMxNy00MGNkLWJmOTktNDUxM2Y5YzYwOTU5IiwidCI6IjEwZWM3OTJjLTU4NzctNGU1ZS05OGE5LTFiMWQ3YTNjM2RlYiIsImMiOjR9
Thanks for sharing! Nice use case for the error bar.
How did you do the shading between the Max and Min lines?
Hi Alex, short answer: Error Bars.
Long answer, the following:
1. You need a measure to be on the lower boundary. On this example, the mininum of the range.
2. Then go to the: Error Bars options of the Line visual..
3. On "Apply settings to", click series Max (important note: you need to have the max measure already put in place on the line visual, as seen below on the Y-axis section)
4. Click on the toggle of Enabled to be: On.
5. Place the minimum DAX measure on the Lower bound slot.
Below a visual reference following the steps mentioned above:
The reason behind the logic of placing the minimum DAX measure on the Lower bound of the max series, is so the band expands from the max series until the minimum line or min series, plotted on the visual itself. You can see on the image above, the "min" measure is put or plotted on Y-axis section of the visual.
Now comes the aesthetics.
6. Collapse the section of "Options"
7. Toggle Off or click on the toggle of the "Bar section" to be "Off"
8. Click on the Error band section.
9. Toggle On or click on the toggle of the "Error band" to be "On"
10. Turn Off or toggle Off the option of "Match series color"
11. Choose the Band color to be white.
12. Adjust the transparency to be 30%.
Below a visual reference following the steps above:
And that's it. A lot of clicking, but -- in my opinion - worth it for informative data graphics. Hope it helps.