Forum Discussion

flex99's avatar
flex99
Helper 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
littlemojopuppy's avatar
littlemojopuppy
Community Champion
6 years ago

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

flex99's avatar
flex99
Helper I
6 years ago

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!

 

 
 
  • littlemojopuppy's avatar
    littlemojopuppy
    Community Champion
    6 years ago

    They should show up when you drop the measure into the visualization.  Can you share a screen snip of what's happening?

    • flex99's avatar
      flex99
      Helper I
      6 years ago

      I tried to attach a screenshot but it didn't work the last time. Here we go again - hope it works...

       

      • littlemojopuppy's avatar
        littlemojopuppy
        Community Champion
        6 years ago

        They're measures so they're going to be reflected with the X axis as well...