Clustered column and two columns in x-axis : how to sort and TOP 15 ?

[JoeMel]

Dear community,
Using a column chart, I have two columns in x-axis and a measure in y-axis.

I would perform a TOP 15 by year, sorted by "Sum_measure".

Pleae could you help me ?

Thank you.

File : Power BI file 

[JoeMel · Accepted solution]

I've found the answer to my question here : Multilevel Sorting in Clustered Column Chart of PowerBI | Nested Sorting for BarChart | Tips & Trick

Thank you.

[DataNinja777]

Hi @JoeMel ,

You can write topn measure like below to achieve your desired output:

Top15CustomerSales = 
VAR TopCustomers = 
    TOPN(
        15,
        SUMMARIZE(
            ALL('Sales'),
            'Sales'[Customer],
            "TotalSales", SUM('Sales'[Sales])
        ),
        [TotalSales],
        DESC
    )
RETURN
IF(
    CONTAINS(TopCustomers, 'Sales'[Customer], SELECTEDVALUE('Sales'[Customer])),
    SUM('Sales'[Sales]),
    BLANK()
)

The resultant output will look like below:

I have attached an example pbix file.