How can I create shaded areas between multiple constant lines?

[imtiazg12345]

Hi, 

How can I create a dynamic shade area between each Y-Axis constant line? I would like for the shade to also adjust with the constant line which moves based on a selected parameter:

Currently if I use the built in shade area option for the all lines, the highest line overlaps over the lower shades. My goal is to only show the color shade between the two constant lines.

Desired Result: would be as follows and should move based on the conditional formatting filled in constant line (with transparancy set to 90% in the image to still see the line from the y-axis measure):

Thanks in advanced.

Kind regards

[V-yubandi-msft]

Hi @imtiazg12345 ,

Can you let us know if your issue is sorted out or if you're still having trouble? Your feedback is super helpful to the community and can assist others who might be facing the same problems.

Thank You.

[imtiazg12345]

Thank you for your response. Using and area and line graph was indeed the solution.

[kpost]

If I were you,  I'd lock the Y axis to be 0 to 10 (optional, as you didn't really specify whether you wanted that or not, but it seems like maybe that is what you want) then re-make a cleaner version of that rainbow pattern, to scale, and save it as an image and make it the background of the plot area.

All I did was take a screenshot of what you made, and then add it as the "Plot Area Background".  I left transparency at 0% but you can change that, too.

///Mediocre Power BI Advice, but it's free///

[imtiazg12345]

Hi, Thank you for your response. How can we tackle this problem when the constant lines are dynamic e.g.?:

[V-yubandi-msft · Accepted solution]

Hi @imtiazg12345 ,

To create a dynamic shaded area between two constant lines in Power BI that adjusts based on a parameter with 90% transparency, and overlay it with a line chart for your Number values, you can use a combination of an Area Chart and a Line Chart.

For more details, please refer to the following Power BI documentation

Use parameters to visualize variables - Power BI | Microsoft Learn
Work with Report view in Power BI Desktop - Power BI | Microsoft Learn
DAX overview - DAX | Microsoft Learn

Thank You.