Forum Discussion
Sort Chart in Columns by Maximum Value
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-ideasRegards,
Vinay Pabbu
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:
-
Small multiples – Use a single chart split into panels by category. Sorting by max value is supported inside this structure.
-
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