Filter holds on while drilling through various visuals in same page in any order

[rds_2019]

Hi,

I have got 3 charts on my Power BI page based on all 3 columns, what i want is

1.when i click on first chart (driven by column1) -Chart 2 (driven by column2) and chart 3 (column3) shows   

corresponding data.

2.Now when I click on chart 2's particular value all filtes should apply for Chart 3 .

So for example- 

Chart1- Click on "aa"

Chart 2- Click on "a"

Chart 3 -> Should show value for nn=11 with Filter Column1=aa AND column2= a

What currently is happening is, when I click on Chart 2  , previous filter of Column1=aa looses thus on 

one filter remains for Chart 3, i.e. column2= a.. And value ends up showing is, since column2=a exists in both aa and bb values of column1 .

Also I wouldi like this to work in either direction Chart1 -> Charts 3 and Chart3 ->1 etc:-

Column1	Column2	Column3	Sale
aa	a	nn	11
bb	a	mm	15

Below is my data:-

Column1	Column2	Column3	Sale
aa	a	nn	11
aa	b	mm	12
aa	c	vv	12
aa	d	vv	13
aa	e	gg	14
aa	f	kk	14
bb	a	mm	15
bb	y	nn	33
bb	t	kl	33
cccc	b	zx	44
cccc	d	gg	44
cccc	c	df	55
cccc	g	sd	66
cccc	j	rf	22
cccc	u	gl	12

Can this be done?

Regards,

RDS

[v-juanli-msft · Accepted solution]

Hi @rds_2019 

Edit interactions for three visuals

The final result as above.

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[CheenuSing]

Hi @rds_2019 

Have you tried creating Slicers for Column1, Column2 and Column3.  This should meet your requirements.

Cheers

CheenuSing

[rds_2019]

Hi @CheenuSing ,

Thanks for replying.

Yes Slicer does solve mypurpose but they look unclean on Report.

I am looking for a way where a clicks on chart get pased as a filter to next chart Or may be another way to filter which looks clean.

Chers,

Raman