Forum Discussion

DHB's avatar
DHB
Icon for Helper V rankHelper 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

     

Phil_Seamark's avatar
Phil_Seamark
Icon for Microsoft Employee rankMicrosoft Employee
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