Matrix ?

[clem312]

Hi,

I need to built a strange matrix :

For each brand, the top 5 items and the percentage associated for that item order by DESC

I have no idea how to built that with Power BI visualisation graphs I know :

[amitchandak]

@clem312 , Create rank , assume you have percentage measure

Rank = rankx(filter(allselcted(Table[Brand], Table[Item]), [Brand] =max([Brand]),[percentage],,desc, dense)

Create a new series 

RankT = generateseries(1,5,1)

Now use this column from RankT on rows of matrix and band on column

Try measures like

maxx(Filter(addcolumns(Summarize(Table, Table[Brand], Table[Item]), "_1", [percentage], "_2", [Rank]), [_2] =max(RankT[Value])), [Item])

refer if needed

Dynamic Segmentation Bucketing Binning
https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-Segmentation-Bucketing-Binning/m-p/1...

Dynamic Segmentation, Bucketing or Binning: https://youtu.be/CuczXPj0N-k

maxx(Filter(addcolumns(Summarize(Table, Table[Brand], Table[Item]), "_1", [percentage], "_2", [Rank]), [_2] =max(RankT[Value])), [percentage])

remove null rankT values or Rank > 5

[clem312]

Hi Amit,

However, I am not able to display the percentage new to the items as in the table I posted. The items are nicely ordered by their rank but the percentage become totally wrong.

Any idea ?

[clem312 · Accepted solution]

Excellent, thank you Amit !