Forum Discussion
Matrix ?
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 :
Excellent, thank you Amit !
3 Replies
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/1387187#M626
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
