Looking to create a diverging bar chart in Power BI? It's a simple but effective chart type for visualizing positive and negative values. In this tutorial, we'll show you how to build a diverging bar chart step-by-step.
First, start with a bar chart of your desired measure, like profit, cut by state. Next, apply color to the bars using the "Format" button, then "Bars", and "Conditional formatting." Set the lowest value to orange, the highest value to blue, and add a white color for the middle value, making sure the middle value is set to zero. This will create a diverging bar chart that shows positive and negative values, with bars going either right or left based on the profit.
How do you build a diverging bar chart in power bi in this example I have a bar chart of profit by state and the bars go either right or left based on the profit Texas has a negative profit and California has a positive profit let's take a look at how to build this in power bi a diverging bar chart is simply a bar chart with a positive and negative value it says bring in a bar chart. Cut it by state and bring in profit.
That's going to give us a bar chart of state and profit you can color the Bars by clicking on the format button clicking on bars and then conditional formatting in this case I want the lowest value to be orange and the highest value to be blue you can add a middle color let's make it white and make sure the middle value is zero click ok and I have a diverging bar chart.
24 авг 2024
