Forum Discussion
Cross page filtering
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
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
Thanks JerriLi for Reply.
Actually now I wants to eloborate what I want to need.
My Table Data is looks like as below.
| STUDENT Name | QUESTION | ANSWER | SurveyID |
| bipin | Which language do you like ? | I love c# | 1 |
| bipin | Which language do you like ? | I love c++ | 2 |
| bipin | Which language do you like ? | I love Java | 3 |
| bipin | What is your professional degree? | MCA | 4 |
| bipin | What is Your Grade? | A+Grade | 5 |
| bipin | Passout Year? | 2007 | 6 |
| Harshad | Which language do you like ? | I love c# | 7 |
| Harshad | Which language do you like ? | I love c++ | 8 |
| Harshad | What is your professional degree? | MCA | 9 |
| Harshad | What is Your Grade? | A++Grade | 10 |
| Harshad | Passout Year? | 2010 | 11 |
| Nishant | Which language do you like ? | I love c | 12 |
| Nishant | Which language do you like ? | I love JS | 13 |
| Nishant | What is your professional degree? | Mtech | 14 |
| Nishant | What is Your Grade? | A+++Grade | 15 |
| Nishant | Passout Year? | 2011 | 16 |
| Rishabh | Passout Year? | 2007 | 17 |
| Rishabh | Which language do you like ? | I love c# | 18 |
| Rishabh | Which language do you like ? | I love c++ | 19 |
| Rishabh | What is your professional degree? | Btech | 20 |
| Rishabh | What is Your Grade? | A++Grade | 21 |
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