Forum Discussion

rds_2019's avatar
rds_2019
Icon for Helper I rankHelper I
7 years ago
Solved

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

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:-

Column1Column2Column3Sale
aaann11
bbamm15

 

Below is my data:-

 

Column1Column2Column3Sale
aaann11
aabmm12
aacvv12
aadvv13
aaegg14
aafkk14
bbamm15
bbynn33
bbtkl33
ccccbzx44
ccccdgg44
cccccdf55
ccccgsd66
ccccjrf22
ccccugl12

 

Can this be done?

 

Regards,

RDS

  • 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.

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi rds_2019 

     

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

     

    Cheers

     

    CheenuSing

    • rds_2019's avatar
      rds_2019
      Icon for Helper I rankHelper I

      Hi Anonymous ,

      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

       

       

  • v-juanli-msft's avatar
    v-juanli-msft
    Icon for Community Support rankCommunity Support

    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.