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

3 Replies

  • 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