Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Drill Down RESET

Hello,   When drilling down into one category, is it possible to have the other categories closed?   Thank you, Tamir
Need Help
v-piga-msft's avatar
v-piga-msft
Icon for Resident Rockstar rankResident Rockstar
8 years ago

Hi Anonymous,

 

I'm a little confused about your sceanrio, could you share some screenshots to describe it in more details?

 

Best  Regards,

Cherry

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi v-piga-msft

 

Please see below snapshot from an Excel Pivot Chart.

I can drill into a specific year (2017 in this example) and see its secondary level and yet, present 2018 only at its top level.

 

 

Thank you,

Tamir

  • v-piga-msft's avatar
    v-piga-msft
    Icon for Resident Rockstar rankResident Rockstar
    8 years ago

    Hi Anonymous,

     

    In Power BI, if you use Drill down it seems won't show like this.

     

    For date hierachy, it will show as Year level, Quarter level, month level, day level.

     

    If you drill down, it will show like below.

     

     

    If you have problems in power pivot, you'd better get help from TechNet forum which should be more  professional..

     

    Best Regards,

    Cherry