Open Side Menu
Skip to contentBrand Logo
Forums
Inspiration
Ideas
Communities
Blogs
Learning
Support
RegisterSign In
  1. Microsoft Fabric Community
  2. Power BI forums
  3. Galleries
  4. Data Stories Gallery
carlosbarboza's avatar
carlosbarboza
Icon for Advocate V rankAdvocate V
1 year ago

P05 - Two Within Band

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, ...
Business
data science
Economics
Global Challenges
Government
Technology
alexpetersensop's avatar
alexpetersensop
New Member
1 year ago

How did you do the shading between the Max and Min lines?

carlosbarboza's avatar
carlosbarboza
Icon for Advocate V rankAdvocate V
1 year ago

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.

 

  • © 2026 Microsoft
  • Manage cookies
  • Privacy & cookies
  • Terms of use
  • Trademarks
Your Privacy Choices Consumer Health Privacy