powerbi

Changing the Color of a Set of Bars of a Clustered Column Chart


I have a clustered column chart where I'm looking at three (3) studies and the number of days it takes each of the 10 regions to perform the studies. I simply want to make all of Region 1 Green, Region 2 Red, etc. But when I change the bar color under the visualizations,it only changes the first instance of three. See below for my source data, PBI fields, attempt to change bar color, and output. Any help would be appreciated!

enter image description here

enter image description here

enter image description here

enter image description here


Solution

  • You need to put your region into the legend part of the settings : Region in Legend

    and then attribute a color to each of your columns : Colors

    And then choose your colors accordingly : colors flow

    And if you need the labels, you can add them from the same place you chose the colors for your columns : Labels

    Hope this helps.