Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Dear All,
i am working on a dashboard and currently i have 4 slicers , my intention is to combine all 4 slicer in one.
My data looks like below
Subjects | Rank1 | Rank2 | Rank3 | Rank4 |
English | John | Clara | Rey | Rey |
Maths | Peter | Roy | Noah | |
Science | Mark | Jezz | Jezz | Peyer |
Currently, my 4 slicers are Rank1,Rank2,Rank3,Rank4,, i am trying to combine these 4 slicers in 1 , named student name so when we select name of student, the whole dashboard is refreshed.
Please help me with it, Many thanks in advance
Your requirements are really unclear, so I don't know if this is what you are after. But I just unpivoted your example data and then created a matrix with subject on rows, rank on the columns and the name in the values
If I understand your requirement correctly the best approach is probably to unpivot the data so that you have a table with subject, rank and person.
eg.
Subjects | Rank | Person |
English | Rank1 | John |
English | Rank2 | Clara |
English | Rank3 | Rey |
English | Rank4 | Rey |
Maths | Rank1 | Peter |
Maths | Rank2 | Roy |
Maths | Rank3 | Noah |
Maths | Rank4 | |
Science | Rank1 | Mark |
Science | Rank2 | Jezz |
Science | Rank3 | Jezz |
Science | Rank4 | Peyer |
@d_gosbell Thanks so much for your reply, i need to show the data in a table as well in the dashboard so i think i wont be able to unpivot 😞
i am trying to create a meaure to do the same , found some resource in the community but unsuccessful:(
@Anonymous wrote:
@d_gosbell Thanks so much for your reply, i need to show the data in a table as well in the dashboard so i think i wont be able to unpivot 😞
You can still do that using a matrix with the unpivoted data
@d_gosbell so sorry, i dont quite get it .. pls help me how to do it?
so i am able to have a single slicer and a table showing the whole data pls.
thanks in advance
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
5 | |
4 | |
1 | |
1 | |
1 |
User | Count |
---|---|
9 | |
4 | |
4 | |
3 | |
2 |