Forum Discussion
Clustered column and Stack bar chart sort
Hello,
I want sort the data in power bi stacked bar and clustered column chart as shown below in the screenshot.
issue - if I sort based on the measure created, header will concatenate and then it will sort based on the measure.
Example - Sort based on the "Asia" from highest to lowest value and graph should look in the same way as column by year and followed by region.
the below image is from excel.
I have Year, region and category(stack) all in seperate table and have to build the relationship at power bi level.
Thanks,
2 Replies
Hi Raaghu ,
Currently power bi desktop could not support Clustered and Stacked column chart .Because it can’t determine which group of series need to be “clustered”, which group of series need to be “stacked”. The expected result as you posted can’t be achieved.
You can vote for this idea or submit the requirement to ideas and add your comments there to make this feature coming sooner: https://ideas.powerbi.com/forums/265200-power-bi-ideas
It is a place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.Best Regards,
Yingjie LiIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
