Forum Discussion

mishrabkm2k14's avatar
mishrabkm2k14
Frequent Visitor
9 years ago
Solved

Cross page filtering

My current scenario is as follows: In a institute there are multiple student have been given the test. In Question paper there 10 question. some questions are single choice and some question have mu...
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    Hi mishrabkm2k14,

     

    According to your description, you just need a single visual(e.g. Stack column chart with x-axis as answer and value as no of student) and a Slicer of "Question" to show number of student for "Answer" of per Question according to your selection.

     

     

    Here is the sample pbix file for your reference. 

     

    Regards

v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
9 years ago

Hi mishrabkm2k14,

 

According to your description, you just need a single visual(e.g. Stack column chart with x-axis as answer and value as no of student) and a Slicer of "Question" to show number of student for "Answer" of per Question according to your selection.

 

 

Here is the sample pbix file for your reference. 

 

Regards

  • mishrabkm2k14's avatar
    mishrabkm2k14
    Frequent Visitor
    9 years ago

    Thanks JerriLi for Reply.

     

    Actually now I wants to eloborate what I want to need.

    My Table Data is looks like as below.

    STUDENT NameQUESTIONANSWERSurveyID
    bipinWhich language do you like ?I love c#1
    bipinWhich language do you like ?I love c++2
    bipinWhich language do you like ?I love Java3
    bipinWhat is your professional degree?MCA4
    bipinWhat is Your Grade?A+Grade5
    bipinPassout Year?20076
    HarshadWhich language do you like ?I love c#7
    HarshadWhich language do you like ?I love c++8
    HarshadWhat is your professional degree?MCA9
    HarshadWhat is Your Grade?A++Grade10
    HarshadPassout Year?201011
    NishantWhich language do you like ?I love c12
    NishantWhich language do you like ?I love JS13
    NishantWhat is your professional degree?Mtech14
    NishantWhat is Your Grade?A+++Grade15
    NishantPassout Year?201116
    RishabhPassout Year?200717
    RishabhWhich language do you like ?I love c#18
    RishabhWhich language do you like ?I love c++19
    RishabhWhat is your professional degree?Btech20
    RishabhWhat is Your Grade?A++Grade21

     

    In above table there are four type of questions.

    Which language do you like ?
    What is your professional degree?
    What is Your Grade?
    Passout Year?

     

    Red color Question have multi-select answer while other questions are single-select answer. It means Each student can give multiple answer for red color question while student will give the only single answer for remaining question.  

     

    Now I wanted to need look lise below graph

     

     

     

    in above 4 graph represent 4 type of question.

     

    What do i want to 

    when user click on one graph data other will filtered accordingly.

     

    Thanks