Forum Discussion
Column Chart with colored target range
Hi, I was wondering if it's possible in Power BI to show a colored target range (like a green bar from 80-90%) within a column chart? Any help will be appreciated! Thanks in advance.
So when I get you both right there's no way to color a range in the graph, but only to color code the bars or to set min/max lines, correct?
How would I exactly create measures for the upper (85%) and lower (75%) boundaries of the range and add them in as lines?
Thanks for your help!
You can use either the PERCENTILE or PERCENTILEX functions to create measures for the 75th and 85th percentiles. From there just drop them into the visualization.
