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

     

DHB's avatar
DHB
Helper V
9 years ago

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.

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

  • DHB's avatar
    DHB
    Helper V
    9 years ago

    Hi GilbertQ,

     

    I tried sorting the two columns with seperate SortBy columns but PBI wasn't happy with it.  I'll give it another try tomorrow.

     

    Thanks,

     

    DHB