Graph Sorting

[FatBlackCat30]

Hi all,

I have a clustered column chart that will correctly sort when you choose a team but when you only choose a metric it wont sort correctly. Is there a way around this issue? 

heres a sample file with the issue PBI Example File 

[Nathaniel_C]

@FatBlackCat30 , Would you save your file on ONE Drive? 

Thank you,

Nathaniel

[FatBlackCat30]

@Nathaniel_C  try this PBI Example  

[Anonymous · Accepted solution]

Hi @FatBlackCat30 

The sort function will sort the values in descending by Categorys in X axis. It won't sort by legend (Team) so when you filter Metric only your result won't sort in descending for cluster columns.

You can try to add Team column into Axis Field and use drill down option when you select Metric only.

Result is as below.

Click the icon in red box to drill down.

Result:

Best Regards,

Rico Zhou

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