Hierarchy problem in Excel 2016 RRS feed

  • Question

  • Hello,

    I created a hierarchy (country, region, city) in the data model and want to use it in reports in Power View.

    The problem is that in Excel 2016, I can't drag the hierarchy to the Filters panel or to the bottom of the Fields List panel , like I can in Excel 2013. I can drag the individual fields in the hierarchy, but that defeats the purpose of creating the hierarchy for me.

    I don't know if I'm doing something wrong now or if the functionality has changed in Excel 2016.

    I am hoping that someone can shed some information on this problem.

    Thank you

    Wednesday, March 30, 2016 10:06 PM


All replies