How to sort for Top-n acount based on region & $ values

[Anonymous]

Hi Guys,

Can someone help me how i can sort the data based on the Rank of the customer & $ value.

Like i have 3 region X,Y,Z and based on the top 3 (highest sales i am getting the output) but it's not sorted.

I am looking like 

Region X --> Account 1 --> $20

                      Account 2 --> $10

                       Account 3 -->$5

Region Y --> Account 1 --> $18

                      Account 2 --> $10

                       Account 3 -->$3

Region Z --> Account 1 --> $12

                      Account 2 --> $11

                       Account 3 -->$10

Rank is my measure. Please suggest how i can sort like above.

Thanks appreciate your help.

[amitchandak]

As of Now Matrix Support, only single sort is supported

 After creating Stepped Layout, sort on the Measure and try

https://www.burningsuit.co.uk/blog/2019/04/7-secrets-of-the-matrix-visual/

[Anonymous]

it's not Matrix graph i am trying ,I am just trying to build the Top N account in bar graph like below.

[v-yiruan-msft]

Hi @Anonymous ,

You can complete the following steps to achieve the requirement:

1. create measures to get the top three accounts per region

sumvalue = SUM ( 'Customers'[Value] )

Top 3 account = 
VAR rankC =
    IF (
        HASONEVALUE ( 'Customers'[Customer] ),
        RANKX ( ALL ( 'Customers'[Customer] ), [sumvalue] )
    )
RETURN
    IF ( rankC <= 3, [sumvalue] )

2. Create Clustered bar chart and drag the related fields (Axis: Region  Legend: Customer  Value: [Top 3 account]) onto visual

Best Regards

Rena

[Anonymous]

Thanks @v-yiruan-msft  this result i got it can you sort like for X region it should come all 3 in sorted format based on the $ values.. and then Y for same and last Z.. Like below 

[v-yiruan-msft · Accepted solution]

Hi @Anonymous ,

Please check if the chart in below screenshot is what you want? If yes, you can use the custom visual "Clustered Column Chart By Akvelon".

Get custom visual "Clustered Column Chart By Akvelon"

Best Regards

Rena

[Anonymous]

Thanks It's working.

[Anonymous]

hi @v-yiruan-msft 

your idea is good but when i am having different accounts name for each region it's not working. In each region it's showing all accounts. Please suggest if there is any way to remove other account which are not belongs to that region