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

     

Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
9 years ago

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)

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