Forum Discussion
Dual sorting on Chart
Hi, I have two tables, 1. Calendar 2. TblSales with 3 columns i.e. Date, Country & Sales Amount (with 3 months data in it.) I have a clustered column chart in which I have put in Shared Axi...
Hi vikrammankar ,
After research, this seems to be impossible to achieve, because your [Country] field is grouped above the [Date] field, which means that there are multiple entries with the same [Country] in the table, so you cannot customize the sort order column to make [ Country] column is sorted by this [amount] column.
I would suggest you add it as an idea on Power BI Ideas to improve Power BI on this feature.
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.