Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Line chart with colored zones

Hi everyone,

 

I am creating a report about comparing the actual data with some reference zones. 

In specific, I would like to create the below chart in Power BI where I have already calculated the lower lines of each reference zone per year as well as the Actual Data per year. However, I could not find the way to implement this. Could you please suggest how I could go about it?

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    I found a roundabout on how to solve it. I created an Area Chart only for the Zones which was send to the background and on top of it I added a Line Chart for the Data. It took some time for fine tuning in order for both chart to work 

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    I found a roundabout on how to solve it. I created an Area Chart only for the Zones which was send to the background and on top of it I added a Line Chart for the Data. It took some time for fine tuning in order for both chart to work 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Amit, no this does not help. Any other suggestions?

    • v-easonf-msft's avatar
      v-easonf-msft
      Community Support
      4 years ago

      Hi, Anonymous 

      You can add an image as a background for this line chart. (format pane->Plot area->add iamge)

       

       

       

      Best Regards,
      Community Support Team _ Eason

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Thank you for your reply. I had thought about that but unfortunately it does not apply to my dashboard as the borders of the zones change depending on the filters chosen.