Forum Discussion
Excel Slicers on data model
Hi, looking for help. I have a couple of tables linked through a survey respondent ID in excel. I can't have the data in the same table because table 1 is the original table with one ID per row, and ...
Slicer is based on the field from some table. If in both charts you use these field from the same table (not same field from different tables) charts shall be connected to the slicer.
Hi, thank you. Yes, the slicer is the same field. The slicer already exists for table 1. I want to use the same slicer for my second table/chart which is connected to the table where the field is, but the table does not show in the report connections list? Confused! Thank you