Forum Discussion

flex99's avatar
flex99
Icon for Helper I rankHelper I
6 years ago

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.
Need Help
flex99's avatar
flex99
Icon for Helper I rankHelper I
6 years ago

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!

  • littlemojopuppy's avatar
    littlemojopuppy
    Icon for Community Champion rankCommunity Champion
    6 years ago

    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.