Conditionally Color-Coding Line Charts in Power BI 📈

Step-by-step walkthrough (PBIX included!)

So, I’ve written about this before, but I recently figured out a better workaround for conditionally color-coding line charts in Power BI 😅. It’s actually pretty simple, and I’ve been using it a lot lately on my current projects.

Unlike bar/column charts — where we can conditionally set the color using the fx — line charts only let us select a single, static color. That can be a big limitation when you want the line color to change based on certain scenarios. In this case, I wanted it to be green if the price of Bitcoin increased and red if it decreased, based on the selected timeframe.

In this article, I’ll walk you through how I built a line chart that dynamically changes color based on Bitcoin’s price variation.

Read the full article here: https://medium.com/the-bi-corner/conditionally-color-coding-line-charts-in-power-bi-3978fd93a2cc

If you don't have Medium, here is a friend link: https://medium.com/the-bi-corner/conditionally-color-coding-line-charts-in-power-bi-3978fd93a2cc?sk=c63128a9f215082db31d56ad1595a69b