Forum Discussion

Madhatter007's avatar
Madhatter007
New Member
2 years ago

Line chart with RAGB background

Hi,

Looked at custom visuals and could not find anything that matched this.

I am looking to create a line chart for KPI, what I would like to have is a background of the RAGB ranges so can easily see where in the range the month is.

I can do this with lines in a bar chart etc, can't figure out how to do it this way.

 

Screen shot is of a user on YT whose created it in Excel.

 

Thank you

 

Need Help
Tips and Tricks
Tutorial Requests

4 Replies

  • rajendraongole1's avatar
    rajendraongole1
    Icon for Super User rankSuper User
    2 years ago

    Hi Madhatter007- Creating a line chart with a background of RAGB ranges in Power BI is not a built-in feature, but you can achieve a similar effect by adding the background images in line chart as below:

     

     

    I have inserted an image on plot area background with RAGB image as background as below

    Format pane >> Plot area background >> "Insert" tab -> "Image" and insert your RAGB background image.

     

     

    Hope it helps.

     

    Did I answer your question? Mark my post as a solution! This will help others on the forum!
    Appreciate your Kudos!!

    • Madhatter007's avatar
      Madhatter007
      New Member
      2 years ago

      Sorry should have been clearer, I would like the RAGB background to be dynamic and mirror the RAGB targets, its a quick visual check of where you are in performance and not a static background.

       

      Thanks

      • rajendraongole1's avatar
        rajendraongole1
        Icon for Super User rankSuper User
        2 years ago

        Hi Madhatter007 - Plot area background with RAGB in Power BI is not a built-in feature. other than the above static image upload.

        you can raise it as an idea in below ideas communities are here:

        Power BI - https://ideas.powerbi.com

         

         

        Did I answer your question? Mark my post as a solution! This will help others on the forum!
        Appreciate your Kudos!!