P05 - Two Within Band
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.