How to add coloured shade area segments in a Line chart

[PeterBrom]

Hi,

I have created a Bell Curve line chart and plotted a point (read score point) on the line (see picture below). What i would like to add is 2 segments, 1 segment for the left side of the red point and 1 segment on the right side and colour them. In order to achieve this i have added a dax calculated column (with the text low and high) in the table.

Is this possible in a line graph ? 

ps: I tried a "line and stacked column chart", see second picture. Now when i changed the entry from the Column y-axis to Line Y-axis i get this, see last picture.

Thank you for advising

[KerKol · Accepted solution]

You could add a X-Axis line in the Analytics pane and shade area before that line, create a second X-Axis line and shade area after that line. It won't create the exact look you are after but would be the simplest workaround.

The second option would be to split your bell curve in to two separate measures so you can colour each section separately.

A third option would be to use a custom visual option such as Deneb.

[PeterBrom]

Hi Kerkol,

Thank you for replying. Excellent idea to split the bell curve in 2, didn’t think about that one.

Much

appreciated.