Stacked Bar graph - no colour option with a legend or multiple values

[Anonymous]

Hi

Has anyone had any issues changing the colour on the stacked bar graph when a legend or multiple values are added? I used to have the option under the format section but now it just shows like this:

This is what it should look like and what I see when there is only one value and no legends:

Any help is appreciated! I've been working around by changing it to a pie graph and changing the colours there then added it back as a stacked bar then putting the X-axis back in. It's not ideal and occasionally doesn't work, I'm positive I was able to change the colour easily a few months ago.

Thanks!

[PijushRoy]

Hi @Anonymous 

If you are using multiple value in X Axis, then you can color based on multiple value in X Axis. It will works same like Legend. For testing purpose, keep one field in X Axis and Legend, you can easily change color as per legend.

If you are using multiple value in X Axis and also one filed in Legend, color can be turn off.

If possible, please create a sample PBIX to reproduce the issue and share the link (google drive/dropbox/onedrive).

Let me know if that works for you

If your requirement is solved, please mark THIS ANSWER as SOLUTION ✔️ and help other users find the solution quickly. Please hit the Thumbs Up 👍 button if this comment helps you.

Thanks
Pijush
Linkedin

[Anonymous]

Thanks ! So this is a mock of two scenarios. I don't think I explained this well. So both of the graphs have the Date as the x-axis, one has only one value and a legend and the other option is 3 values. 

[Anonymous]

ID	Legend	Value 1	Value 2	Value 3	Month End Registered
1	Yes	0	1	0	31/01/2024
2	No	0	1	0	31/01/2024
3	Yes	0	1	0	31/01/2024
4	Yes	0	0	1	31/01/2024
5	No	0	0	1	31/01/2024
6	No	0	0	1	29/02/2024
7	Yes	0	0	1	31/01/2024
8	Yes	0	1	0	31/01/2024
9	Yes	1	0	0	29/02/2024
10	Yes	1	0	0	31/01/2024
11	No	1	0	0	31/01/2024
12	No	0	1	0	31/01/2024
13	No	0	0	1	29/02/2024
14	Yes	0	0	1	29/02/2024
15	Yes	0	0	1	31/01/2024
16	Yes	1	0	0	29/02/2024
17	Yes	1	0	0	29/02/2024
18	Yes	1	0	0	29/02/2024
19	Yes	1	0	0	31/01/2024
20	Yes	1	0	0	29/02/2024
21	No	0	0	1	29/02/2024
22	No	0	0	1	29/02/2024

This is the mock data set I'm using 

[Arul]

@Anonymous ,

Conditional formatting won't be possible if you are using values in legend.