topic Re: Slicer on multiple columns in Report Server

Slicer on multiple columns

Anonymous — Wed, 26 Oct 2022 09:59:13 GMT

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

Re: Slicer on multiple columns

d_gosbell — Wed, 26 Oct 2022 23:33:18 GMT

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

Re: Slicer on multiple columns

Anonymous — Wed, 26 Oct 2022 23:37:16 GMT

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:(

Re: Slicer on multiple columns

d_gosbell — Wed, 26 Oct 2022 23:44:44 GMT

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

Re: Slicer on multiple columns

Anonymous — Thu, 27 Oct 2022 01:00:09 GMT

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

Re: Slicer on multiple columns

d_gosbell — Thu, 27 Oct 2022 02:21:58 GMT

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