Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
amranwali
New Member

Sort clustered column chart based on two levels: first total deals by bank and then by year

I have a dataset that looks like below.

I'd like to create a clustered column chart that is sorted by bank with the highest count of total deals and then by year.

At the moment, my chart looks like the below.

The order should be Bank A (2019, 2021, 2022), Bank B (2019, 2020), Bank C (2021, 2022)

Is there a way I can do this?

 

BankYearDeal
Bank A2019Company 1
Bank A2019Company 2
Bank A2021Company 3
Bank A2021Company 4
Bank A2022Company 5
Bank A2022Company 6
Bank B2019Company 7
Bank B2019Company 8
Bank B2020Company 9
Bank B2020Company 10
Bank C2021Company 11
Bank C2022Company 12

Deals_By_Bank.png

2 REPLIES 2
amranwali
New Member

Thank you Vicky. But I'm still having the same issue. I think the example I gave was bad because the deal in each year for each bank was the same.

What is the table had more deals for 2022?

How can you sort by total deal count for the bank and the year?

Eg. 

BankYearDeal
Bank A2019Company 1
Bank A2019Company 2
Bank A2021Company 3
Bank A2021Company 4
Bank A2022Company 5
Bank A2022Company 6
Bank A2022Company 7
Bank A2022Company 8
Bank A2022Company 9
Bank A2022Company 10
Bank A2022Company 11
Bank B2019Company 12
Bank B2019Company 13
Bank B2020Company 14
Bank B2020Company 15
Bank C2021Company 16
Bank C2022Company 17
vicky_
Super User
Super User

vicky__0-1679435183701.png

You can put bank and year on the same x-axis. If the order is sorted incorrectly, click the three dots and check that it makes sense there

Helpful resources

Announcements
PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors