Millington Offices (10).png

Power BI Viz Tricks - Line chart target areas

Updated: 2 days ago

A few months ago, I was asked to build a line chart with target areas, something like the chart below (which by the way will be our final solution!):

At the time I could not really find an easy way to achieve this... Until error bars came out!

Don't be fooled though, it's still a bit tricky to build a line chart like this, however I found it way easier now than before.

So, you must be thinking now "how did you do that?".

Well, let's find out!

1) I started out with my base chart, which is just showing Profit Over Time. I'm just using a simple sum measure for the profit, and a Date field from my data. Nothing too fancy.

2) Now we are going to work on the "Above Target" Area, or the one in green in the first image of this blog post.

To do this, we are going to use the Error Bars feature.

Even though the intention of this feature was not really for this kind of purpose, there is no limit to creativity in Power BI and you can, and should, be creative with all the formatting options in Power BI.

To start, we are going to the Advanced Options tab in the formatting pane, and then open the Error Bars section:

Once you open the Error Bars Section you will see something like this: