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 multiple choice. this is like

Student IDStudent EmailQuestion AnswerAnswerID
101[email protected]Question1a101011
101[email protected]Question1b101012
101[email protected]Question1c101013
101[email protected]Question1d101014
101[email protected]Question2a101015
101[email protected]Question3d101016
102[email protected]Question1b101017
102[email protected]Question2c101018
102[email protected]Question3b101019

 

what do I want to do,

1- All the question shows as column.

2- created a model into power BI desktop.

3- created a three visuals (Graph) as per Question 1 2 3.

In x-axis- as answer

In y-axis as no of student

 

So I wanted to apply cross filtering on these three graph.

Is this any feasible solution in power BI

 

Thanks

 

  • 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

2 Replies

  • 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