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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Anonymous
Not applicable

Custom Sorting Legend

Hi There,

 

I have a chart (see attached) that displays totals for one year vs the other i.e FY23/FY22.

 

I want to have the data sorted so that the outcomes i.e promoted/demoted etc are side by side for comparitive purposes. Is this possible to move them side by side ?

 

Appreciate any help here 🙂

 

Capture.PNG

1 ACCEPTED SOLUTION

@Anonymous You need to set your original Outcomes column to have a Sort By column of Outcome Sort. You do this in the Column tools tab of the ribbon. Then, you use your original Outcome column in your visualization and it will be sorted in the order of Outcome Sort column.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

4 REPLIES 4
Anonymous
Not applicable

ohh apologies think im mistaken -- i still use original outcome column but sort it by outcome sort ?

Greg_Deckler
Super User
Super User

@Anonymous In Power Query, duplicate your Outcome column. Then, create a calculated column in DAX like this:

Outcome Sort = 
  SWITCH('Table'[Outcome Dup],
    "FY22 Demoted",1,
    "FY22 Promoted",2,
    "FY22 Failed",3,
    "FY22 Maintained,4,
    "FY23 Demoted",5,
    "FY23 Promoted",6,
    "FY23 Failed",7,
    "FY23 Maintained,8
  )

Set the Sort By column for Outcome to Outcome Sort.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...
Anonymous
Not applicable

Thanks @Greg_Deckler this has worked however it has now changed the outcome names to 1,2,3,4,5,6,7,8 as a result.

 

Any reason for this ?

 

Capture.PNG

@Anonymous You need to set your original Outcomes column to have a Sort By column of Outcome Sort. You do this in the Column tools tab of the ribbon. Then, you use your original Outcome column in your visualization and it will be sorted in the order of Outcome Sort column.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.