locked
bi directional filtering pivot report and slicer RRS feed

  • Question

  • Hi eb

    Are excel 2016 slicers aware of data filtered in the pivot report area?

    Say reports rows are filtered by a filter or by another slicer - will other slicers, attached to this pivot, show only members that are left with data (assuming slicer is configured to show members with data only)?

    TIA

    Rea

    Thursday, February 16, 2017 2:52 PM

Answers

  • Are excel 2016 slicers aware of data filtered in the pivot report area?

    No they are not, slicers filter pivot tables. Filters applied directly in the pivot table do not affect slicers

    http://darren.gosbell.com - please mark correct answers

    Thursday, February 16, 2017 9:15 PM

All replies

  • Are excel 2016 slicers aware of data filtered in the pivot report area?

    No they are not, slicers filter pivot tables. Filters applied directly in the pivot table do not affect slicers

    http://darren.gosbell.com - please mark correct answers

    Thursday, February 16, 2017 9:15 PM
  • Thanks

    I think the pbi desktop solves this issue where  slicer and data tables are joined with 'filter direction' set to 'both tables' in the data model.

    Am I right about that?

    Hopefully this is true  where model is in SSAS tabular and the pbi desktop is used as presentation layer only??

    Thanks again!

    Rea

    Sunday, February 19, 2017 8:54 AM
  • I think the pbi desktop solves this issue where  slicer and data tables are joined with 'filter direction' set to 'both tables' in the data model.

    Am I right about that?

    Hopefully this is true  where model is in SSAS tabular and the pbi desktop is used as presentation layer only??

    The issue here is not the relationships in the data model. The problem is that Excel Pivot tables do not publish out their selected items to other charts or slicers. PBI works differently than Excel and one a given page a selection (such as when a user clicks on the bars of a bar char) on one chart will filter other charts, but if you filter in the chart settings that will not flow through to other charts. Filtering the data on the chart is different to making a selection.

    http://darren.gosbell.com - please mark correct answers

    Sunday, February 19, 2017 10:27 PM