Sorting Stacked Column Chart by Akvelon

[cmccully]

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!

[Anonymous]

Does anybody know how to fix this?

[amitchandak]

@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

[cmccully]

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:

[v-kelly-msft]

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:

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

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

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[cmccully]

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.

[parry2k]

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

[cmccully]

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

[cmccully]

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.

[v-kelly-msft]

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!

[cmccully]

Sorry but hte issue is not yet resolved.

[Alice-Jen]

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

[cmccully]

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.

[Alice-Jen]

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.

[Anonymous]

Hi @cmccully 

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

[cmccully]

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.

[parry2k]

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