Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!!
Solved! Go to Solution.
is your sort by column of numerical type? it should be numerical
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
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 ....
Try sort the column in the database itself, Did you try that ?
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 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.
Hi @parry2k ...Thank you!!
Its solved..I had to set the Gl/Source ID as whole number.
@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.
is your sort by column of numerical type? it should be numerical
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |