topic Re: Cross page filtering in Developer

Cross page filtering

mishrabkm2k14 — Wed, 16 Nov 2016 12:24:37 GMT

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 ID	Student Email	Question	Answer	AnswerID
101	abc@abc.com	Question1	a	101011
101	abc@abc.com	Question1	b	101012
101	abc@abc.com	Question1	c	101013
101	abc@abc.com	Question1	d	101014
101	abc@abc.com	Question2	a	101015
101	abc@abc.com	Question3	d	101016
102	abc2@abc.com	Question1	b	101017
102	abc2@abc.com	Question2	c	101018
102	abc2@abc.com	Question3	b	101019

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

Re: Cross page filtering

v-ljerr-msft — Thu, 17 Nov 2016 06:42:43 GMT

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

Problem on Cross page filtering

mishrabkm2k14 — Fri, 18 Nov 2016 23:40:47 GMT

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