Forum Discussion
charmainer
Helper III
Helper IIITop 3 values in a row in Table
I am looking at a way to represent the top 3 valsue in a row. Currently data in SQL database 2016 : On premises is there a way in PowerBi to reperesent to 3 value in a row? in my example i wan...
charmainerHelper III
Helper IIIHi Thanks for that.
I have tried to unpivot ... but i have duplicate values in the real data ( i have just given you a sample) .
Will get back to you with what i have come back with. i might change the real data and upload it to see how to over come the dupliecat values.
Kind Regards
Charmaine
charmainerHelper III
Helper IIIHi,
Back to my top 3 with new version of Matrix
i have upgraded to the new version of BI desktop (sep 2017).
With better sample data,
I have used the latest matrix feature which allows to show columns as rows.
attached pic.
The final list is i want the above to only list the TOP 3 vlaues and Ranks per student( as for each student only list the underlined)
in the Matrix above or
listed like below
| Studnet ID | Ranked 1 | Ranked 2 | Ranked 3 |
| 567 | Judgement Rank | Honesty Rank | Humanity Rank |
| 566 | Leadership Rank | Humor Rank | Fairness Rank |
Any suggestions ?