Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Slicer on multiple columns

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 ...
DAX
DAX ALL PowerBI Excel
d_gosbell's avatar
d_gosbell
Super User
3 years ago

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
  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

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

     

    • d_gosbell's avatar
      d_gosbell
      Super User
      3 years ago
      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

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        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