Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I want to create a 100 % stacked bar chart which has data like below
Ticket | Created | Time spent | state | Index |
id 1 | 10/24/2023 16:49 | 1 | P4 | 1 |
id 1 | 10/24/2023 17:23 | 0 | P4 | 1 |
id 1 | 10/24/2023 17:40 | 1 | P2 | 2 |
id 1 | 10/24/2023 18:02 | 0 | P2 | 2 |
id 1 | 10/24/2023 18:07 | 0 | P2 | 2 |
id 1 | 10/24/2023 18:10 | 0 | P2 | 2 |
id 1 | 10/24/2023 18:38 | 0 | P2 | 2 |
id 1 | 10/24/2023 18:49 | 0 | P3 | 3 |
id 1 | 10/24/2023 18:50 | 13 | P3 | 3 |
id 1 | 10/25/2023 7:13 | 0 | P3 | 3 |
id 1 | 10/25/2023 7:18 | 0 | P3 | 3 |
id 1 | 10/25/2023 7:21 | 1 | P3 | 3 |
id 1 | 10/25/2023 8:20 | 0 | P3 | 3 |
id 2 | 10/24/2023 16:49 | 1 | P4 | 1 |
id 2 | 10/24/2023 17:23 | 0 | P4 | 1 |
id 2 | 10/24/2023 17:40 | 1 | P2 | 2 |
id 2 | 10/24/2023 18:02 | 0 | P2 | 2 |
id 2 | 10/24/2023 18:07 | 0 | P2 | 2 |
id 2 | 10/24/2023 18:10 | 0 | P2 | 2 |
id 2 | 10/24/2023 18:38 | 0 | P2 | 2 |
id 2 | 10/24/2023 18:49 | 0 | P3 | 3 |
id 2 | 10/24/2023 18:50 | 13 | P3 | 3 |
id 2 | 10/25/2023 7:13 | 0 | P3 | 3 |
id 2 | 10/25/2023 7:18 | 0 | P3 | 3 |
id 2 | 10/25/2023 7:21 | 1 | P3 | 3 |
id 2 | 10/25/2023 8:20 | 0 | P3 | 3 |
in y-axis=Ticket, x-axis=Time spent, legend=Index, but this legend does not give the same colors for all state in a id. Also, tried sorting column state using Sort by column index which gives an error such as"there can't be more than one value in index for the same state". Would really be helpfull if there's a way to sort state by index and it should have same colors for all ticket id.
Please Note: The legend has to be sorted by index+it should same colors for every state in each id as well well over all other id's.
Thanks for your help in advance
@ValtteriN , if you turn off legend and switch on custom label and put state there, you can observe that color for each state is different because of the sequence/index. Thus i want the sequence+same colors, is this possible in dax to have it sorted and assign colors same colors to states and put this as a legend?
Hi,
Could you add an image of the issue? Generally speaking the color should be the same between the columns since you can adjust it on series level:
Proud to be a Super User!