Sort Chart in Columns by Maximum Value

[Syndicate_Admin]

Good morning

I don't know if my posts are published correctly

I have created a viewer and I want to organize the graphs in columns by maximum value, and have them change dynamically depending on the selected values.

I have found that with the "Area Chart" type of chart it does work, but I wanted the charts to be in columns since I consider it to be more visual. Attached screenshots

I've searched through more visuals to find a chart but I don't see it.

I'm sure it's simple.

Thank you very much community.

[Syndicate_Admin]

Thank you for your answer.

I share capture with area charts, in that case it does sort the values within the chart, which is what I would like to have in bars or columns instead of a line.

Do you confirm that it is not possible to do so without the options you tell me about?

[v-vpabbu]

Hi @Syndicate_Admin,

If you're trying to use multiple separate bar/column charts (one per category), and want those entire visuals to reorder themselves (like a dashboard rearranging blocks based on data) — Power BI does not support this.

Regards,

Vinay Pabbu

[Syndicate_Admin]

Thanks for the answer.

I want PowerBi to make an update and allow us to change the design of the tree graph to another type of figure -horizontal columns, vertical columns etc- that way we would have a solution to the problem I pose

[v-vpabbu · Accepted solution]

Hi @Syndicate_Admin,

That’s a great idea and would definitely add flexibility to Power BI visuals!

I recommend submitting this feedback through Microsoft’s official Ideas forums, such as the Microsoft Fabric Ideas portal. Ideas submitted there are regularly reviewed by the product teams and have a strong chance of influencing future improvements.
https://ideas.fabric.microsoft.com/ideas/search-ideas 

Regards,

Vinay Pabbu

[v-vpabbu]

Hi @Syndicate_Admin,

As we haven't heard back from you, I hope you have raised a Idea. At this time we are closing this thread. If you have any further issues, please start a new thread in the community forum, and we are here to assist you. Thankyou for your understanding and continuous support.
Thank you for being part of the Microsoft Fabric Community.

Regards,

Vinay Pabbu

[Ritaf1983]

Hi @Syndicate_Admin 

You're trying to dynamically sort multiple visuals (charts) based on their maximum values, so that the position of each chart changes according to the selected data. This isn't supported in Power BI.

Visuals in Power BI are static objects on the canvas. There's no built-in way to reorder them dynamically based on data – even if you sort the data within each chart, the position of the visuals themselves won’t change.

When you say it works with an "Area Chart," it likely refers to sorting the values within the chart, not the layout of separate visuals.

Alternatives:

1. Small multiples – Use a single chart split into panels by category. Sorting by max value is supported inside this structure.

2. Single chart with slicers – Instead of separate visuals, create one chart and use a slicer or field parameter to change what's displayed.

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly