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, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
cmccully
Helper I
Helper I

Sorting Stacked Column Chart by Akvelon

Hello

 

I would like to know if there is anyway to sort the Akvelon Stacked Column Chart? In the standard charts we can select a sort order and what to sort by but I see no such controls for the Akvelon chart. Thanks!

 

Sorting bar charts.jpg2020-04-23_16-48-59.jpg

16 REPLIES 16
Anonymous
Not applicable

Does anybody know how to fix this?

amitchandak
Super User
Super User

@cmccully , Mark a sort column for the given column and check if it works. https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

Thank you for your response. Unfortuneatly the Akvelon visualization does not seem to have the same sort controls available in the standard charts. Here is what the menu looks like on the Akvelon chart:

 

2020-04-23_16-48-59.jpg

v-kelly-msft
Community Support
Community Support

Hi @cmccully ,

 

Go to data view>Click on the dropdown button of a certain column you wanna sort,then select the sorting order,as you see below:

Annotation 2020-04-24 102259.png

If you want  the column sorted by another column,select the column ,then go to menu bar>column tools >sort by column,shown below:

Annotation 2020-04-24 102553.png

Finally you will see the visual sort by the order you select. (In below sample,I choose sorting by date)

Annotation 2020-04-24 102952.png

Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!

Kelly

 

Thank you for your response. I sorted by the quarter column but this did not effect the order of my charts as desired. I added another image to better explain what I am going after. The Akvelon visualization breaks the data down into several individual charts as shown below. I want the individual charts displayed by quarter as I have numbered below.

 

2020-04-24_8-32-29.jpg

parry2k
Super User
Super User

@cmccully as you now it is a custom visual, you need to reach out to the developer to find out.

 



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.

Thank you, I have reached out to Akvelon and will post any suggestions they provide.

Akvelon let me know they have no future plans to fix this issue. It might happen some day but they are focusing on other issues.

Hi @cmccully

 

Is your issue solved?If it is solved,could you pls mark the reply as answered to close it?

 

 
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!

Sorry but hte issue is not yet resolved.

Is your issue solved?Could you post any suggestions Akvelon provide?Thanks you in advance. I have a same issue. 

Akvelon let me know they have no future plans to fix this issue. It might happen some day but they are focusing on other issues.

Thank you for your reply.

This can be solved by another way. For example ,I want to sort by md column(by date) but it is sorted by alfabet order. So I just select this md column and set sort by column like below.

The chart will be sorted by date.  The axis x of my chart is md.

AliceJen_0-1670579356483.png

 

Anonymous
Not applicable

Hi @cmccully 

 

Has your issue been resolved? Or have you found any workarounds?

Akvelon let me know they have no future plans to fix this issue. It might happen some day but they are focusing on other issues.

@cmccully that's exactly my first reply to this post was, glad you are following that step. good luck.



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.

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

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

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

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