Multiple 100% Stacked bar charts aligning
Hi Community! My three 100% stacked bar charts aren't lining up properly at the starting point (I've marked the desired alignment with a red line). I think it's because the Y-axis value (State, City, and Company names) have different lengths. Is there a way to make the bars start at the same point, even with uneven label lengths? Any help would be greatly appreciated! Thank you! Dummy Power BI Dashboard from Power BI Desktop Here is the dummy dataset I used
100% stacked bar chart - sort of text column by index with same colors in legend
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 advancecalculate time spent in each state
i have a data as given below Ticket num Created state Ticket_1 11/3/2022 0:06 P4 Ticket_1 11/3/2022 0:18 P4 Ticket_1 11/3/2022 0:21 P3 Ticket_1 11/3/2022 0:22 P2 Ticket_1 11/3/2022 0:23 P1 Ticket_1 11/3/2022 0:24 P1 Ticket_1 11/3/2022 0:26 P1 Ticket_2 12/12/2022 13:40 P1 Ticket_2 12/12/2022 13:41 P1 Ticket_2 12/12/2022 13:43 P2 Ticket_2 12/12/2022 13:45 P2 Ticket_2 12/12/2022 13:45 P4 Ticket_2 12/12/2022 13:46 P3 Ticket_2 12/13/2022 14:00 P1 i would now like to calculate time spent by each state in hours/seconds for every ticket in a 100% stacked bar chart and see the transition for state for Ticket_1 which changes from P4-->P3-->P2-->P1 Final chart to look something like this
