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

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
Icon for Community Champion rankCommunity 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
    Icon for Helper I rankHelper 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
      Icon for Community Champion rankCommunity Champion
      6 years ago

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

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

        Ok, so what would be needed to make the dotted lines go from side to side? Is there a way?