Forum Discussion
Column Chart with colored target range
Sorry, I don't get it though I'd really love to know how you created the dotted lines in your above example.
I'm not able to create a constant value of 75% with the Percentile function and "drop it into the visual" would also need some more words. When I use a combo chart and throw it in as 'line value' I will get a line between distinct data points but would rather like to have an independent line over the entire width of the chart.
Here's code I used to calculate the 75th percentile...
Observation Value 75th Percentile =
PERCENTILEX.EXC(
FILTER(
ALL(Observations),
Observations[ObservationType] = SELECTEDVALUE(Observations[ObservationType])
),
Observations[Value],
.75
)
If what you're looking for if just a constant 75% and 85%, just create a measure like this
Percent75 = .75
Percent85 = .85
To get the dotted lines, in the Formatting menu for the visualization, go to Shapes, Customize Series and then play with the settings
Thanks, that helped a lot! I was indeed merely looking for the ".075" measure 🙂
One thing I couldn't manage is to get the dotted lines across the entire X axis (starting from the y axis and over to the very right). Is that somehow possible? It looked like on the screenshot you provided earlier!
They should show up when you drop the measure into the visualization. Can you share a screen snip of what's happening?
I tried to attach a screenshot but it didn't work the last time. Here we go again - hope it works...