How can I change color for different bar where the legend is on the same bar

[mumbea]

Hi everyone, after searching for days in this forum I haven't find the answer to my problem. I have two measures and the total, divided for companies and for years. I want a multiple bar chart where are shown both measures on the same column (with different color) for each company grouped by year.

This are the kind of data.

Company	year	value	measure
A	2020	5	big
A	2019	6	big
A	2018	7	big
B	2020	5	big
B	2019	6	big
B	2018	7	big
C	2020	5	big
C	2019	6	big
C	2018	7	big
A	2020	-1	little
A	2019	-0.5	little
A	2018	0.2	little
B	2020	-1	little
B	2019	-0.5	little
B	2018	0.2	little
C	2020	-1	little
C	2019	-0.5	little
C	2018	0.2	little

I want the year on the X axis, grouped by company ( as legend do) and I want to have the total breakdown (with different color) for big and little measures. So I want to use 6 colors. To do something acceptable I make three bar chart for the years and then I use the company as X axis with the legend made by the variable "measure". For me it is ok even to make three graphics, but I want to use different color for each company (for example the companies red, green and blue, but with that color light for big and dark for little).

I know is something strange, I hope you can help me.

[v-jayw-msft]

Hi @mumbea ,

You can't have two legend fields in a stacked column chart. Maybe you should consider to use custom visuals.

Best Regards,

Jay

[mumbea]

Thank you @amitchandak and @amitchandak for the answers, this is what I've done and what I want. I want the separation of the two component and each bar with a couple of color. Up in the picture I divide by year and I use the measure to separate on the same column, down there is my dream, but I can't underline the two part of the sum. The solution made by Pragati11 is good, but I can't see well how much 'small' is big related to 'big'

Thank you in advance

 

[Pragati11]

Hi @mumbea ,

You can use a BAR CHART visual with Small Multiples in it. Somehting like below:

You can format the chart for colours, labelling etc. as per your need.

Thanks,

Pragati

[amitchandak]

@mumbea , the Expected output is not clear. But conditional formatting does work with legend and more than one measure.

You can have a measure and both columns on-axis and try conditional formatting. Refer to the power bi part in this video - https://www.youtube.com/watch?v=2P5BBRN853c