Forum Discussion
Switch groups in 100% Stacked chart
There sure is. Just add a new column to your table that will control the sort order of your Legend column
So please add the following column
Legend Sort = IF('mytable'[Legendcol] = 'Y' , 0 , 1 )Then specify the sort order of your existing column to use this new column using the Sort By Column feature
There sure is. Just add a new column to your table that will control the sort order of your Legend column
So please add the following column
Legend Sort = IF('mytable'[Legendcol] = 'Y' , 0 , 1 )
Then specify the sort order of your existing column to use this new column using the Sort By Column feature
That's great thanks Phil.
The issue I have now is that I can't sort another column in the same table. It says Sort By Another Column Error - This column can't be sorted by a column that is already sorted, directly or indirectly , by this column. Can I only do this once per table?
Oh ok, it looks like you can't then. I haven't come across that. I take it you have another Y/N column in your table?
Perhaps just create some more sorting columns (which you can hide)
Yes, I have two Y/N columns in the same table. Thank you for your trick for sorting one column, I'll definitely be able to use that elsewhere.
Hi DHB,
As Phil_Seamark suggested create another SortBy Column for your additional column.
You can most definitely then use your additional SortBy column on your additional column.
