how to highlight area in line chart?

[Donia12215]

Hi

I have a line chart and I want to highlight the area of ​​expected values ​​(as in the example below). Is it possible?

[Daryl-Lynch-Bzy · Accepted solution]

Hi @Donia12215  - Using the standard Line Chart I think it is only possible to add Upper and Lower y constant line.

You may want have a look a custom visuals or charticulator.  To get this effect.

[Daryl-Lynch-Bzy · Accepted solution]

Hi @Donia12215 , I have to apologise.  I overlooked a new preview feature that was relased in March 2022 call error bars.  This preview feature needs to be enabled in the Options / Preview Features:

When this is enabled an additional option appears in the "Analysis" setting pane:

  

To make this work you need to include measures for the Upper and Lower bound.  This measure can be hard coded with a number (e.g. 80), or set relative to the existing measure (e.g. 80% of [Measure]).  Once the Upper and Lower bound are set, you need to toggle the Shaded Area on and the Bar off.

This is the impact:

[Donia12215]

It works! Thank you so much for your help! 😊

[Daryl-Lynch-Bzy · Accepted solution]

Hi @Donia12215  - Using the standard Line Chart I think it is only possible to add Upper and Lower y constant line.

You may want have a look a custom visuals or charticulator.  To get this effect.