Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
DHB
Helper V
Helper V

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 at the bottom?

 

Thank you,

 

DHB

 

 

1 ACCEPTED SOLUTION
Phil_Seamark
Microsoft Employee
Microsoft Employee

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

 

Sort by mont.png


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

View solution in original post

7 REPLIES 7
Phil_Seamark
Microsoft Employee
Microsoft Employee

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

 

Sort by mont.png


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

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?

Phil_Seamark
Microsoft Employee
Microsoft Employee

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)


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

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.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

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

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

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.