Line charts with conditional formatting

I recently discovered something accidentally in Power BI that might be useful. My colleague Mihaly found a similar technique by accident too a day or so before, so I thought I’d share what we found.

We ended up creating a line chart with conditionally formatted markers :

It’s really quite simple to achieve. Here’s my simple data set:

First I create a simple column chart:

Then in the formatting options, set up conditional formatting on the bars:

Which then results in this:

At that point simple switch the visual to a line chart:

You can also use the format painter to copy apply from one chart to another.

It’s very unlikely that this is supported by Power BI, so use in the knowledge that is might stop working.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s