Forum Discussion

DHB's avatar
DHB
Helper V
9 years ago
Solved

Switch groups in 100% Stacked chart

I'm using a 100% Stacked chart and the legend is either Y or N.  I have the N coming up at the bottom of the bar and Y from the top.  Is there any way I can switch those two around so that Y starts a...
Tips and Tricks
  • Phil_Seamark's avatar
    Phil_Seamark
    9 years ago

    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

     

GilbertQ's avatar
GilbertQ
Super User
9 years ago

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.

DHB's avatar
DHB
Helper V
9 years ago

I've got it now.  I'd been creating sorting columns that referenced the column I wanted to sort.  All working perfectly.  

 

Thanks so much for your help.

 

DHB