Combine multiple clustered bar charts

[Anonymous]

Greetings! I am new to Power BI. I am trying to create a clustered bar chart that shows top 5 products by sales by year. Unfortunately, the top 5 products change from one year to another. Currently, if I select multiple years on the years slicer, it aggregates the sales and identifies the top 5 products by aggregate sales, not by sales for each year. i've created a clustered bar chart for each of the years in question, but I would like to combine these charts into one. Any help would be greatly appreciated!

Regards,

Darin

[v-yingjl]

Hi @Anonymous ,

In power bi desktop, I'm afraid it is not supported to combine multiple clustered column chart into a single visual currently. The sort by function in the visuals is based on the axis column value as a sigma value so even you use slicers to filter, the visuals will also aggreate all values and sort based on the total.

Perhaps you can submit the requirement to ideas and add your comments there to help us improve power bi and make this feature coming sooner: https://ideas.powerbi.com/forums/265200-power-bi-ideas

For more information about sort by, you can also refer: Sort by column in Power BI Desktop 

Best Regards,
Yingjie Li

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

[Greg_Deckler]

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490