Data Colors Updated in 100% Stacked Column Chart - Power BI

[Anonymous]

Hi,

I am using 100% Stacked Column chart as given below. 

In the X-Axis you can see I have given two brands. I need the data colors based on this two brands and not based on the Total and Staged orders. Brand 1 should be with dark blue for total orders and light blue for staged orders. In the same way Brand 2 should be with dark red for total orders and light red for staged orders. 

I tried giving the brand names in legend and it is not accepting.

[Anonymous]

Hi @Anonymous 

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file from your Onedrive for Business.

Best Regards,

Rico Zhou

[Anonymous · Accepted solution]

Hi @Anonymous 

Due to I don't know your data model, I build a sample to have a test.

Table:

I think your data model may like the table above, but you can't add the legend due to you don't have a specific column for it. And if you want to change the color of Total order and  staged order, you need to add the legend.

So, you need to transform the table in PowerQuery Editor.

Select Total Order and Stage order column and unpivote the select column. Then duplicate Brand column and merge Attribute column and new Brand column.

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WcipKzEsxVNJRAmEDpVgdwkKGqEIGVBSioSOMMM0ywjTLCLdGLKoMCArhsJE4IcKOgArFAgA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Brand = _t, TotalOrder = _t, Stage = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Brand", type text}, {"TotalOrder", Int64.Type}, {"Stage", Int64.Type}}),
    #"Unpivoted Only Selected Columns" = Table.Unpivot(#"Changed Type", {"TotalOrder", "Stage"}, "Attribute", "Value"),
    #"Duplicated Column" = Table.DuplicateColumn(#"Unpivoted Only Selected Columns", "Brand", "Brand - Copy"),
    #"Merged Columns" = Table.CombineColumns(#"Duplicated Column",{"Attribute", "Brand - Copy"},Combiner.CombineTextByDelimiter("", QuoteStyle.None),"Merged")
in
    #"Merged Columns"

 Result:

Just like  Greg_Deckler replied before, this time you can change the color in Date colors.

You can download the pbix file from this link: Data Colors Updated in 100% Stacked Column Chart 

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

[Greg_Deckler]

@Anonymous  Not sure about that, definitely not how it is configured right now. You can only set the colors of the values like that. Can't seem to get there using a legend either. and I do not see conditional formatting available either (fx)