Forum Discussion
Sort clustered bar chart
Hi all,
I would like to sort this bar chart by the count of Involved in Investigation = True but can't seem to achieve it via the sort by axis. Any help would be much appreciated!
Hi Anonymous ,
_AAndrade , This method can only sort the contents of the axis, not the contents of the Legend.
If you must sort Involved in Investigation = True, you can try this approach.
Here is my sample dataset:I use there DAXs to create measures:
True = SUMX(FILTER('Table','Table'[Involved in Investigation]="True"), 'Table'[Value])False = SUMX(FILTER('Table','Table'[Involved in Investigation]="False"), 'Table'[Value])Then put these measures into the bar chart:
Then you can change the sorting rules:
This is just an example, you will need to change the DAX you use for your specific situation.
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
I've done a quick example and as you can see it's possible to sort using this path:
Hi Anonymous ,
_AAndrade , This method can only sort the contents of the axis, not the contents of the Legend.
If you must sort Involved in Investigation = True, you can try this approach.
Here is my sample dataset:I use there DAXs to create measures:
True = SUMX(FILTER('Table','Table'[Involved in Investigation]="True"), 'Table'[Value])False = SUMX(FILTER('Table','Table'[Involved in Investigation]="False"), 'Table'[Value])Then put these measures into the bar chart:
Then you can change the sorting rules:
This is just an example, you will need to change the DAX you use for your specific situation.
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
