cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
djk1000 Frequent Visitor
Frequent Visitor

Re: Custom Sorting in PowerBI?

@ahxl

 

You can do essentially the same thing, creating your COLUMNSORT column, but do it in the Query Editor with "Add Column", then save and sort by the new column back out  in the PowerBI intrerface. It will get rid of the circular dependency.

pmuralikrishna1 Frequent Visitor
Frequent Visitor

Re: Custom Sorting in PowerBI?

Re-creating visualization worked for me. Thank you

bassm Frequent Visitor
Frequent Visitor

Re: Custom Sorting in PowerBI?

Same for me. I had to delete my chart and create again.

 

Thanks for the tip. A good work around. 

kunalmishra07 Frequent Visitor
Frequent Visitor

Re: Custom Sorting in PowerBI?

Hi All, 

Thank you for sharing the solution. 

 

1. By using reference table

2. Conditional Column

 

I was wondering what is the difference between doing it by using Conditional column and doing the same with calculated column. 

 

Steps Followed :-

1. Go to Data Tab

2. Go to Modelling ribon and select New column

3. Create column using reference column according to what we need to sort. 

 

But sorting is not happening and i am getting error that Reference column could not be sort by Calculated column.

 

Request you to throw light on the same.

ffro3 Frequent Visitor
Frequent Visitor

Re: Custom Sorting in PowerBI?

Awesome tip!

I was struggling to reorder certain data, but this worked like a charm!

 

Thanks a lot!!

mvanwyns Frequent Visitor
Frequent Visitor

Re: Custom Sorting in PowerBI?

All these workarounds for just a simple sort task, unbeleivable how difficult it is

 

I just can't get this crap worked out

NiallMaguire Frequent Visitor
Frequent Visitor

Re: Custom Sorting in PowerBI?

Agreed! This is such a basic feature, why it requires such a workaround seems absurd!

leharkapil Member
Member

,Although I have used my sorter column as default column to sort, Im oRe: Custom Sorting in PowerBI?

Hi,

 

Although I have used my sorted column as default column to be used as a sort, Im not able to see my bar chart change the sort automatically.

Highlighted
christ7 Frequent Visitor
Frequent Visitor

Re: Custom Sorting in PowerBI?

How did everyone put the ID in the second column in the newly created table?

What formula is it?

Abhilash241 Frequent Visitor
Frequent Visitor

Re: Custom Sorting in PowerBI?

Hi Everyone,

 

This option seems to be completely not working when i tried the same procedure and sorted the stacked column chart my chart started showing all as 100% for all items.

 

Suggest .

 

Thanks,

Abhilash

Helpful resources

Announcements
Coming Soon: T-Shirt Design Contest

Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors
Top Kudoed Authors