Forum Discussion

vikrammankar's avatar
vikrammankar
Frequent Visitor
4 years ago

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 Axis,

"Date Hierarchy" from Calendar Table &

Country from "TblSales" Table.

 

In Column Values I have put Sales Amount from "TblSales" Table.

 

I want to sort this chart first on date as ascending and then on Sales Amount as descending.  I am able to achieve this in table visual, however I am unable to achieve it in chart visual.

 

Mentioned below is the sample data for TblSales. 

Date                 Country      Sales Amount
01-Jan-2021    US              100
01-Jan-2021    UK              150
01-Jan-2021    UAE            200
01-Feb-2021    US             500
01-Feb-2021    UK             450
01-Feb-2021    UAE           300
01-Mar-2021    US             820
01-Mar-2021    UK             850
01-Mar-2021    UAE           700

 

Best Regards,

Vikram.

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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.