topic 100% stacked bar chart - sort of text column by index with same colors in legend in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/100-stacked-bar-chart-sort-of-text-column-by-index-with-same/m-p/3624522#M140130 <P>Hi,</P><P>I&nbsp; want to create a 100 % stacked bar chart which has&nbsp; data like below</P><TABLE><TBODY><TR><TD>Ticket</TD><TD>Created</TD><TD>Time spent</TD><TD>state</TD><TD>Index</TD></TR><TR><TD>id 1</TD><TD>10/24/2023 16:49</TD><TD>1</TD><TD>P4</TD><TD>1</TD></TR><TR><TD>id 1</TD><TD>10/24/2023 17:23</TD><TD>0</TD><TD>P4</TD><TD>1</TD></TR><TR><TD>id 1</TD><TD>10/24/2023 17:40</TD><TD>1</TD><TD>P2</TD><TD>2</TD></TR><TR><TD>id 1</TD><TD>10/24/2023 18:02</TD><TD>0</TD><TD>P2</TD><TD>2</TD></TR><TR><TD>id 1</TD><TD>10/24/2023 18:07</TD><TD>0</TD><TD>P2</TD><TD>2</TD></TR><TR><TD>id 1</TD><TD>10/24/2023 18:10</TD><TD>0</TD><TD>P2</TD><TD>2</TD></TR><TR><TD>id 1</TD><TD>10/24/2023 18:38</TD><TD>0</TD><TD>P2</TD><TD>2</TD></TR><TR><TD>id 1</TD><TD>10/24/2023 18:49</TD><TD>0</TD><TD>P3</TD><TD>3</TD></TR><TR><TD>id 1</TD><TD>10/24/2023 18:50</TD><TD>13</TD><TD>P3</TD><TD>3</TD></TR><TR><TD>id 1</TD><TD>10/25/2023 7:13</TD><TD>0</TD><TD>P3</TD><TD>3</TD></TR><TR><TD>id 1</TD><TD>10/25/2023 7:18</TD><TD>0</TD><TD>P3</TD><TD>3</TD></TR><TR><TD>id 1</TD><TD>10/25/2023 7:21</TD><TD>1</TD><TD>P3</TD><TD>3</TD></TR><TR><TD>id 1</TD><TD>10/25/2023 8:20</TD><TD>0</TD><TD>P3</TD><TD>3</TD></TR><TR><TD>id 2</TD><TD>10/24/2023 16:49</TD><TD>1</TD><TD>P4</TD><TD>1</TD></TR><TR><TD>id 2</TD><TD>10/24/2023 17:23</TD><TD>0</TD><TD>P4</TD><TD>1</TD></TR><TR><TD>id 2</TD><TD>10/24/2023 17:40</TD><TD>1</TD><TD>P2</TD><TD>2</TD></TR><TR><TD>id 2</TD><TD>10/24/2023 18:02</TD><TD>0</TD><TD>P2</TD><TD>2</TD></TR><TR><TD>id 2</TD><TD>10/24/2023 18:07</TD><TD>0</TD><TD>P2</TD><TD>2</TD></TR><TR><TD>id 2</TD><TD>10/24/2023 18:10</TD><TD>0</TD><TD>P2</TD><TD>2</TD></TR><TR><TD>id 2</TD><TD>10/24/2023 18:38</TD><TD>0</TD><TD>P2</TD><TD>2</TD></TR><TR><TD>id 2</TD><TD>10/24/2023 18:49</TD><TD>0</TD><TD>P3</TD><TD>3</TD></TR><TR><TD>id 2</TD><TD>10/24/2023 18:50</TD><TD>13</TD><TD>P3</TD><TD>3</TD></TR><TR><TD>id 2</TD><TD>10/25/2023 7:13</TD><TD>0</TD><TD>P3</TD><TD>3</TD></TR><TR><TD>id 2</TD><TD>10/25/2023 7:18</TD><TD>0</TD><TD>P3</TD><TD>3</TD></TR><TR><TD>id 2</TD><TD>10/25/2023 7:21</TD><TD>1</TD><TD>P3</TD><TD>3</TD></TR><TR><TD>id 2</TD><TD>10/25/2023 8:20</TD><TD>0</TD><TD>P3</TD><TD>3</TD></TR></TBODY></TABLE><P>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&nbsp; state using <STRONG>Sort by column</STRONG> 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.</P><P>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.</P><P>Thanks for your help in advance</P> Tue, 09 Jan 2024 05:30:54 GMT Bu__ 2024-01-09T05:30:54Z 100% stacked bar chart - sort of text column by index with same colors in legend https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/100-stacked-bar-chart-sort-of-text-column-by-index-with-same/m-p/3624522#M140130 <P>Hi,</P><P>I&nbsp; want to create a 100 % stacked bar chart which has&nbsp; data like below</P><TABLE><TBODY><TR><TD>Ticket</TD><TD>Created</TD><TD>Time spent</TD><TD>state</TD><TD>Index</TD></TR><TR><TD>id 1</TD><TD>10/24/2023 16:49</TD><TD>1</TD><TD>P4</TD><TD>1</TD></TR><TR><TD>id 1</TD><TD>10/24/2023 17:23</TD><TD>0</TD><TD>P4</TD><TD>1</TD></TR><TR><TD>id 1</TD><TD>10/24/2023 17:40</TD><TD>1</TD><TD>P2</TD><TD>2</TD></TR><TR><TD>id 1</TD><TD>10/24/2023 18:02</TD><TD>0</TD><TD>P2</TD><TD>2</TD></TR><TR><TD>id 1</TD><TD>10/24/2023 18:07</TD><TD>0</TD><TD>P2</TD><TD>2</TD></TR><TR><TD>id 1</TD><TD>10/24/2023 18:10</TD><TD>0</TD><TD>P2</TD><TD>2</TD></TR><TR><TD>id 1</TD><TD>10/24/2023 18:38</TD><TD>0</TD><TD>P2</TD><TD>2</TD></TR><TR><TD>id 1</TD><TD>10/24/2023 18:49</TD><TD>0</TD><TD>P3</TD><TD>3</TD></TR><TR><TD>id 1</TD><TD>10/24/2023 18:50</TD><TD>13</TD><TD>P3</TD><TD>3</TD></TR><TR><TD>id 1</TD><TD>10/25/2023 7:13</TD><TD>0</TD><TD>P3</TD><TD>3</TD></TR><TR><TD>id 1</TD><TD>10/25/2023 7:18</TD><TD>0</TD><TD>P3</TD><TD>3</TD></TR><TR><TD>id 1</TD><TD>10/25/2023 7:21</TD><TD>1</TD><TD>P3</TD><TD>3</TD></TR><TR><TD>id 1</TD><TD>10/25/2023 8:20</TD><TD>0</TD><TD>P3</TD><TD>3</TD></TR><TR><TD>id 2</TD><TD>10/24/2023 16:49</TD><TD>1</TD><TD>P4</TD><TD>1</TD></TR><TR><TD>id 2</TD><TD>10/24/2023 17:23</TD><TD>0</TD><TD>P4</TD><TD>1</TD></TR><TR><TD>id 2</TD><TD>10/24/2023 17:40</TD><TD>1</TD><TD>P2</TD><TD>2</TD></TR><TR><TD>id 2</TD><TD>10/24/2023 18:02</TD><TD>0</TD><TD>P2</TD><TD>2</TD></TR><TR><TD>id 2</TD><TD>10/24/2023 18:07</TD><TD>0</TD><TD>P2</TD><TD>2</TD></TR><TR><TD>id 2</TD><TD>10/24/2023 18:10</TD><TD>0</TD><TD>P2</TD><TD>2</TD></TR><TR><TD>id 2</TD><TD>10/24/2023 18:38</TD><TD>0</TD><TD>P2</TD><TD>2</TD></TR><TR><TD>id 2</TD><TD>10/24/2023 18:49</TD><TD>0</TD><TD>P3</TD><TD>3</TD></TR><TR><TD>id 2</TD><TD>10/24/2023 18:50</TD><TD>13</TD><TD>P3</TD><TD>3</TD></TR><TR><TD>id 2</TD><TD>10/25/2023 7:13</TD><TD>0</TD><TD>P3</TD><TD>3</TD></TR><TR><TD>id 2</TD><TD>10/25/2023 7:18</TD><TD>0</TD><TD>P3</TD><TD>3</TD></TR><TR><TD>id 2</TD><TD>10/25/2023 7:21</TD><TD>1</TD><TD>P3</TD><TD>3</TD></TR><TR><TD>id 2</TD><TD>10/25/2023 8:20</TD><TD>0</TD><TD>P3</TD><TD>3</TD></TR></TBODY></TABLE><P>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&nbsp; state using <STRONG>Sort by column</STRONG> 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.</P><P>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.</P><P>Thanks for your help in advance</P> Tue, 09 Jan 2024 05:30:54 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/100-stacked-bar-chart-sort-of-text-column-by-index-with-same/m-p/3624522#M140130 Bu__ 2024-01-09T05:30:54Z Re: 100% stacked bar chart - sort of text column by index with same colors in legend https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/100-stacked-bar-chart-sort-of-text-column-by-index-with-same/m-p/3624707#M140136 <P>Hi,<BR /><BR />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:<BR /><BR /></P> <P><img /></P> <P>&nbsp;</P> Tue, 09 Jan 2024 06:00:02 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/100-stacked-bar-chart-sort-of-text-column-by-index-with-same/m-p/3624707#M140136 ValtteriN 2024-01-09T06:00:02Z Re: 100% stacked bar chart - sort of text column by index with same colors in legend https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/100-stacked-bar-chart-sort-of-text-column-by-index-with-same/m-p/3624987#M140146 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="343431" data-lia-user-login="ValtteriN" class="lia-mention lia-mention-user">ValtteriN</a>&nbsp;, 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&nbsp; assign colors same colors to states and put this as a legend?</P> Tue, 09 Jan 2024 07:21:36 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/100-stacked-bar-chart-sort-of-text-column-by-index-with-same/m-p/3624987#M140146 Bu__ 2024-01-09T07:21:36Z