Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago

Issue with Excel drilldown and hidden columns

I have an SSAS Tabular model where I hide several columns.  In Excel 2013 I do not see the columns in the Pivot Table Field List.  When I double click on a value and drilldown, the hidden columns appear.  What am I missing?

 

model.png

Need Help

1 Reply

  • Rémi's avatar
    Rémi
    Resolver III
    10 years ago

    Hi,

     

    The drill down option into Excel is for Power View.

    Activate "Power View" complement, then do Insertion > Power View.

    It will add a new tab PowerView1 and you can do visualisations or pivot table here.

    You can do a drill down now.