Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
06-26-2025 15:23 PM - last edited 06-26-2025 15:36 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.
You can download the pbix file below. Feel free to poke it.
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.