Can powerbi use a matrix as a data source?

My dataset is about sales. It has categories, subcategories, region, country and account detail, among others.

I'm trying to create a vis that can show me what absolute and what proportion of revenue was derived by the top a,b,c accounts, where abc might be 10, 50, 100 for example, and display these for the last few fiscal year periods. I'd like to be able to slice these data by category and our geography, and have the option to in or exclude a subset of accounts (which I can easily identify programmatically).

I got started with the ranking function on the source data, but don't have my head around how I can then slice these data as the slicing by definition alters the ranking outcomes.

I haven't asked that well, but hopefully it's a start - I'd welcome thoughts on how to better ask the question even so I can google it better 🙂

Cheers.