Forum Discussion

ilcaa72's avatar
ilcaa72
Icon for Helper IV rankHelper IV
8 years ago

Visually Filter on Bank ID but not Dates

I have 2 tables.  I i want to use as a Filter and 1 I want to use to view data.   in table 1, i want to select a Bank ID to filter the right hand table on BUT i dont want the dates to be filtered, ...
Need Help
v-yuta-msft's avatar
v-yuta-msft
Icon for Community Support rankCommunity Support
8 years ago

Hi ilcaa72,

 

If you click on one value in BankID column, it means one row has been selected so that chart on the right hand will be filtered by that row. In your senario, I would recommend you to create a slicer chart based on BandID column then you can use the slicer chart to filter the matrix.

 

Regards,

Jimmy Tao

ilcaa72's avatar
ilcaa72
Icon for Helper IV rankHelper IV
8 years ago

thanks Jimmy.  i know if i select the Bank ID on the row the matrix will filter based on date as well... that is why I posted.  I need to see the date but dont want to filter the matrix (2nd table) on dates, only on BankID.  Is this possible?  if so how

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi ilcaa72 did you ever figure this out? I am trying to do it as well! It seems like must do!