top of page

Custom Bar Colors in Power BI

Updated: Jul 31, 2023

Building a visualization that shows performance to goal is a common practice in BI. Often the “Line and Clustered Column Chart” visualization is used. The line typically shows the goal and the bars show the actual metric for the given period. An excellent way to draw quick attention to the periods that have achieved the goal is to dynamically change the color of the bar when the goal is met or exceeded.

custom power bi colors

Below is an example of a visualization that shows monthly Sales Amount (bars) and the Sales Goal (dashed line). Each time the value of the Sales Amount exceeds the value of the Sales Goal, the color is set to green. When the Sales Amount falls short of the Sales Goal, the bar color is set to tan.