Can powerbi use a matrix as a data source?

[unusdusrname]

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.

[amitchandak]

@unusdusrname , Not very clear. But if you want to use Rank for sorting (Sort column) then it needs to be static. and can not change with slicer selection

The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.