<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Re: P05 - Two Within Band in Data Stories Gallery</title>
    <link>https://community.fabric.microsoft.com/t5/Data-Stories-Gallery/P05-Two-Within-Band/m-p/4747294#M14626</link>
    <description>&lt;P&gt;&lt;FONT face="arial,helvetica,sans-serif"&gt;Hi Alex, short answer: Error Bars.&amp;nbsp;&lt;/FONT&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;/P&gt;&lt;P&gt;&lt;FONT face="arial,helvetica,sans-serif"&gt;Long answer, the following:&lt;/FONT&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;FONT face="arial,helvetica,sans-serif"&gt;1. You need a measure to be on the lower boundary. On this example, the mininum of the range.&lt;/FONT&gt;&lt;/P&gt;&lt;P&gt;&lt;FONT face="arial,helvetica,sans-serif"&gt;2. Then go to the: &lt;STRONG&gt;Error Bars&lt;/STRONG&gt; options of the Line visual..&lt;/FONT&gt;&lt;/P&gt;&lt;P&gt;&lt;FONT face="arial,helvetica,sans-serif"&gt;3.&amp;nbsp; 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)&lt;/FONT&gt;&lt;BR /&gt;&lt;FONT face="arial,helvetica,sans-serif"&gt;4. Click on the toggle of Enabled to be: On.&lt;/FONT&gt;&lt;/P&gt;&lt;P&gt;&lt;FONT face="arial,helvetica,sans-serif"&gt;5. Place the minimum DAX measure on the Lower bound slot.&amp;nbsp; &lt;/FONT&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;FONT face="arial,helvetica,sans-serif"&gt;Below a visual reference following the steps mentioned above:&amp;nbsp;&amp;nbsp;&lt;/FONT&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;FONT face="arial,helvetica,sans-serif"&gt;&lt;img /&gt;&lt;/FONT&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;FONT face="arial,helvetica,sans-serif"&gt;The reason behind the logic of placing the &lt;STRONG&gt;minimum DAX measure&lt;/STRONG&gt; on the &lt;STRONG&gt;Lower bound&lt;/STRONG&gt; of the &lt;STRONG&gt;max series&lt;/STRONG&gt;, is so the band expands from the max series until the minimum line or min series, plotted on the visual itself.&amp;nbsp; You can see on the image above, the "min" measure is put or plotted on Y-axis section of the visual.&lt;/FONT&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;FONT face="arial,helvetica,sans-serif"&gt;Now comes&amp;nbsp;the aesthetics.&lt;/FONT&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;FONT face="arial,helvetica,sans-serif"&gt;6. Collapse the section of "Options"&lt;/FONT&gt;&lt;/P&gt;&lt;P&gt;&lt;FONT face="arial,helvetica,sans-serif"&gt;7. Toggle Off or click on the toggle of the "Bar section" to be "Off"&lt;/FONT&gt;&lt;/P&gt;&lt;P&gt;&lt;FONT face="arial,helvetica,sans-serif"&gt;8. Click on the Error band section.&lt;/FONT&gt;&lt;/P&gt;&lt;P&gt;&lt;FONT face="arial,helvetica,sans-serif"&gt;9. Toggle On or click on the toggle of the "Error band" to be "On"&lt;/FONT&gt;&lt;/P&gt;&lt;P&gt;&lt;FONT face="arial,helvetica,sans-serif"&gt;10. Turn Off or toggle Off the option of "Match series color"&lt;/FONT&gt;&lt;BR /&gt;&lt;FONT face="arial,helvetica,sans-serif"&gt;11. Choose the Band color to be white.&lt;/FONT&gt;&lt;/P&gt;&lt;P&gt;&lt;FONT face="arial,helvetica,sans-serif"&gt;12. Adjust the transparency to be 30%.&lt;/FONT&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;FONT face="arial,helvetica,sans-serif"&gt;Below a visual reference following the steps above:&amp;nbsp;&lt;/FONT&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;FONT face="arial,helvetica,sans-serif"&gt;&lt;img /&gt;&amp;nbsp;&lt;/FONT&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;FONT face="arial,helvetica,sans-serif"&gt;And that's it. A lot of clicking, but -- in my opinion - worth it for informative data graphics. Hope it helps.&lt;/FONT&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
    <pubDate>Sat, 28 Jun 2025 15:18:42 GMT</pubDate>
    <dc:creator>carlosbarboza</dc:creator>
    <dc:date>2025-06-28T15:18:42Z</dc:date>
    <item>
      <title>P05 - Two Within Band</title>
      <link>https://community.fabric.microsoft.com/t5/Data-Stories-Gallery/P05-Two-Within-Band/m-p/4745768#M14615</link>
      <description>&lt;P&gt;&lt;FONT face="arial,helvetica,sans-serif"&gt;&lt;SPAN&gt;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 &lt;STRONG&gt;&lt;A href="https://www.clearlyandsimply.com/clearly_and_simply/2011/04/an-underrated-chart-type-the-band-chart.html" target="_blank" rel="noopener"&gt;the band chart&lt;/A&gt;&lt;/STRONG&gt;.&lt;/SPAN&gt;&lt;/FONT&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;FONT face="arial,helvetica,sans-serif"&gt;&lt;SPAN&gt;For a copy of the pbix file, feel free to message me at &lt;STRONG&gt;&lt;A href="https://www.linkedin.com/in/merod/" target="_self"&gt;LinkedIn&lt;/A&gt;&lt;/STRONG&gt;&amp;nbsp;&lt;/SPAN&gt;&lt;/FONT&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;SPAN class="reportid hidden"&gt;eyJrIjoiNDNiZjc4YTAtMjMxNy00MGNkLWJmOTktNDUxM2Y5YzYwOTU5IiwidCI6IjEwZWM3OTJjLTU4NzctNGU1ZS05OGE5LTFiMWQ3YTNjM2RlYiIsImMiOjR9&lt;/SPAN&gt;&lt;/P&gt;</description>
      <pubDate>Mon, 02 Feb 2026 01:00:52 GMT</pubDate>
      <guid>https://community.fabric.microsoft.com/t5/Data-Stories-Gallery/P05-Two-Within-Band/m-p/4745768#M14615</guid>
      <dc:creator>carlosbarboza</dc:creator>
      <dc:date>2026-02-02T01:00:52Z</dc:date>
    </item>
    <item>
      <title>Re: P05 - Two Within Band</title>
      <link>https://community.fabric.microsoft.com/t5/Data-Stories-Gallery/P05-Two-Within-Band/m-p/4746910#M14621</link>
      <description>&lt;P&gt;How did you do the shading between the Max and Min lines?&lt;/P&gt;</description>
      <pubDate>Fri, 27 Jun 2025 17:43:55 GMT</pubDate>
      <guid>https://community.fabric.microsoft.com/t5/Data-Stories-Gallery/P05-Two-Within-Band/m-p/4746910#M14621</guid>
      <dc:creator>alexpetersensop</dc:creator>
      <dc:date>2025-06-27T17:43:55Z</dc:date>
    </item>
    <item>
      <title>Re: P05 - Two Within Band</title>
      <link>https://community.fabric.microsoft.com/t5/Data-Stories-Gallery/P05-Two-Within-Band/m-p/4747294#M14626</link>
      <description>&lt;P&gt;&lt;FONT face="arial,helvetica,sans-serif"&gt;Hi Alex, short answer: Error Bars.&amp;nbsp;&lt;/FONT&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;/P&gt;&lt;P&gt;&lt;FONT face="arial,helvetica,sans-serif"&gt;Long answer, the following:&lt;/FONT&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;FONT face="arial,helvetica,sans-serif"&gt;1. You need a measure to be on the lower boundary. On this example, the mininum of the range.&lt;/FONT&gt;&lt;/P&gt;&lt;P&gt;&lt;FONT face="arial,helvetica,sans-serif"&gt;2. Then go to the: &lt;STRONG&gt;Error Bars&lt;/STRONG&gt; options of the Line visual..&lt;/FONT&gt;&lt;/P&gt;&lt;P&gt;&lt;FONT face="arial,helvetica,sans-serif"&gt;3.&amp;nbsp; 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)&lt;/FONT&gt;&lt;BR /&gt;&lt;FONT face="arial,helvetica,sans-serif"&gt;4. Click on the toggle of Enabled to be: On.&lt;/FONT&gt;&lt;/P&gt;&lt;P&gt;&lt;FONT face="arial,helvetica,sans-serif"&gt;5. Place the minimum DAX measure on the Lower bound slot.&amp;nbsp; &lt;/FONT&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;FONT face="arial,helvetica,sans-serif"&gt;Below a visual reference following the steps mentioned above:&amp;nbsp;&amp;nbsp;&lt;/FONT&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;FONT face="arial,helvetica,sans-serif"&gt;&lt;img /&gt;&lt;/FONT&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;FONT face="arial,helvetica,sans-serif"&gt;The reason behind the logic of placing the &lt;STRONG&gt;minimum DAX measure&lt;/STRONG&gt; on the &lt;STRONG&gt;Lower bound&lt;/STRONG&gt; of the &lt;STRONG&gt;max series&lt;/STRONG&gt;, is so the band expands from the max series until the minimum line or min series, plotted on the visual itself.&amp;nbsp; You can see on the image above, the "min" measure is put or plotted on Y-axis section of the visual.&lt;/FONT&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;FONT face="arial,helvetica,sans-serif"&gt;Now comes&amp;nbsp;the aesthetics.&lt;/FONT&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;FONT face="arial,helvetica,sans-serif"&gt;6. Collapse the section of "Options"&lt;/FONT&gt;&lt;/P&gt;&lt;P&gt;&lt;FONT face="arial,helvetica,sans-serif"&gt;7. Toggle Off or click on the toggle of the "Bar section" to be "Off"&lt;/FONT&gt;&lt;/P&gt;&lt;P&gt;&lt;FONT face="arial,helvetica,sans-serif"&gt;8. Click on the Error band section.&lt;/FONT&gt;&lt;/P&gt;&lt;P&gt;&lt;FONT face="arial,helvetica,sans-serif"&gt;9. Toggle On or click on the toggle of the "Error band" to be "On"&lt;/FONT&gt;&lt;/P&gt;&lt;P&gt;&lt;FONT face="arial,helvetica,sans-serif"&gt;10. Turn Off or toggle Off the option of "Match series color"&lt;/FONT&gt;&lt;BR /&gt;&lt;FONT face="arial,helvetica,sans-serif"&gt;11. Choose the Band color to be white.&lt;/FONT&gt;&lt;/P&gt;&lt;P&gt;&lt;FONT face="arial,helvetica,sans-serif"&gt;12. Adjust the transparency to be 30%.&lt;/FONT&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;FONT face="arial,helvetica,sans-serif"&gt;Below a visual reference following the steps above:&amp;nbsp;&lt;/FONT&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;FONT face="arial,helvetica,sans-serif"&gt;&lt;img /&gt;&amp;nbsp;&lt;/FONT&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;FONT face="arial,helvetica,sans-serif"&gt;And that's it. A lot of clicking, but -- in my opinion - worth it for informative data graphics. Hope it helps.&lt;/FONT&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Sat, 28 Jun 2025 15:18:42 GMT</pubDate>
      <guid>https://community.fabric.microsoft.com/t5/Data-Stories-Gallery/P05-Two-Within-Band/m-p/4747294#M14626</guid>
      <dc:creator>carlosbarboza</dc:creator>
      <dc:date>2025-06-28T15:18:42Z</dc:date>
    </item>
    <item>
      <title>Re: P05 - Two Within Band</title>
      <link>https://community.fabric.microsoft.com/t5/Data-Stories-Gallery/P05-Two-Within-Band/m-p/4747661#M14627</link>
      <description>&lt;P&gt;Thanks for sharing! Nice use case for the error bar.&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Sun, 29 Jun 2025 20:36:09 GMT</pubDate>
      <guid>https://community.fabric.microsoft.com/t5/Data-Stories-Gallery/P05-Two-Within-Band/m-p/4747661#M14627</guid>
      <dc:creator>MasonMA</dc:creator>
      <dc:date>2025-06-29T20:36:09Z</dc:date>
    </item>
  </channel>
</rss>

