Forum Discussion
manojk_pbi
Helper V
Helper Vhelp need in Sorting Stacked Bar charts
Hi Friends, I am looking for a suggestion on adding sort in Stacked bar charts on Legends. Please suggest how this can be achieved. I don't see any option which sorts my data using legends. Attac...
lbendlin
Super User
Super UserIn the regular world a column can only be sorted by itself or by another column, not by a measure. ( Ashish_Mathur may know a trick using visual type switching )
Even a DAX column will result in a circular reference, so you would need to create that sort column in Power Query.
This of course no longer makes it dynamic. But it produces the desired result.
manojk_pbiHelper V
Helper VThanks lbendlin for your reply. I will try it on my data set. I am just wondering about performance of this query on data when we have large data. Data which i had provided is aggregated and sample.