locked
Cascading Filters -- functionality or Tabular model config RRS feed

  • General discussion

  • Hey

    I have an 2012 Excel file running off a Tabular model,

    The Table in the model is a [Partner] consisting of Partner Name and Type

    What I want it to do

    If I choose X Partner Type the Partners (Names) are dynamically filtered to illustrated the associated Partners (Cascading Filter)

    Filter Partner Names Value is dependent on Filter Partner Type's selection 

    Question

    Am I right in saying a Pivot table in excel does not support this? it works when I add a slicer but not with the traditional old school drop down Filters

    Is it a Tabular model config issue or excel functionality limitation?

    The specific Table ([Partner]) in the model does not have a hierarchy , other than sorting the fields will adding a hierarchy invoke this functionality? why does it work when I add a Slicer, is what confuses me; this to me is what rules out Tabular model config

    Thursday, June 27, 2013 2:49 PM

All replies