Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
Hi @Frances1
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
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.
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