Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Drill through report not working as expected

Hi All,

I have created a drill through report and it is not working as expected. I have a main report summary level and slicers. When i select 2020 and then click on the drill through to goto the detailed report it is showing all the years and not just 2020. Please advice.

 

Thanks

Need Help

7 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Thanks, please see the attached screen shots, the first two are from the main report. No filters ONLY SLICERS and the 3rd one is the detailed report.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Did not understand your question.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Thank you , it is not clear as to where i need to make these changes. In the main report or the report that i need to drill to? Also i do not see the options of summarized and used as category.

      • parry2k's avatar
        parry2k
        Icon for Super User rankSuper User
        6 years ago

        Anonymous it will on drill thru page, and summary/category will show if the column is a number, it is not critical for you,, just use category.

         

        I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

        ⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡