Solved: Re: Sorting by Particular Column in a hierarchy

Anonymous · ‎03-05-2019

Hi,

I have this Actual Revenue & Expenses Matrix table.

I want the Hierarchy to be in this Order (Image !), but I want the GL/Source Summary Account Title fiels to be sorted in particular Order.

I tried creating a conditional column with GL/Source Account Summary ID & sorted the GL/Source title column by the ID column.

But it doesn't work.

I will really appreciate any help on this.

Thanks!!

bogomda · ‎03-06-2019

is your sort by column of numerical type? it should be numerical

View solution in original post

v-lili6-msft · ‎03-05-2019

HI, @Anonymous

Add an index column for GL/Source Summary Account Title in Edit Queries.

For example:

Then set sort by column

Result:

Best Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous · ‎03-06-2019

Hi @v-lili6-msft ,

Thank you for your reply.

I did the same way...but it still doesn't work.

Don't know what I am missing ....

Anonymous · ‎11-13-2020

Try sort the column in the database itself, Did you try that ?

bogomda · ‎03-06-2019

seems like you did everything right, but you might probably forgot to do following:

on the visual itself, => choose more options => choose Sorty By => choose GL/Source Summary Account Title.

Below is the example. Once you do it, it should resort it in your desired order.

Anonymous · ‎03-06-2019

I did that too...:(

Thank you @bogomda !!

parry2k · ‎03-06-2019

@Anonymous can you confirm and make sure you sorted your ("GL/Source SUmmary Account Title" by "Account SUmmary Id" in model tab using "sort by column"

Can you send the screen shot if you did it?

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Anonymous · ‎03-06-2019

Hi @parry2k ...Thank you!!

Its solved..I had to set the Gl/Source ID as whole number.

parry2k · ‎03-06-2019

@Anonymous that make sense. glad to hear. cheers

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.