Forum Discussion

vrv's avatar
vrv
Helper II
5 years ago
Solved

drill down by date and user

hi all,

I just created my frist report in Pwer BI. I was able to drill down on year, quarter and month, however, when I click on any monthly column I want to see a brekdown by user.

Given that the data is essentially in a table like this:

myDateTime                    myUser         pageHit

2020-09-01 10:00:01       user1             1

2020-09-01 10:00:10       user1             1

2020-09-01 11:00:00       user2             1

.....

how do I add user to the date hierarchy?

thanks,

vrv

  • Hi vrv ,

     

    You can do this in two way creating a custom hierarchy that you can use on your X-axis or an easier way it so drag the user column also to the x-axis after the date hierarchy that will give you an extra level of hierarchy.

     

     

4 Replies

  • Hi vrv ,

     

    You can do this in two way creating a custom hierarchy that you can use on your X-axis or an easier way it so drag the user column also to the x-axis after the date hierarchy that will give you an extra level of hierarchy.

     

     

    • vrv's avatar
      vrv
      Helper II

      I dragged the user field not on the graph on the x-axis but rather in the Visualization section under Axis where it has been added as a further drill down hierarchy (with one level).

       

      Thanks you very much,

      Regards,

      vv

      • MFelix's avatar
        MFelix
        Super User

        Hi vrv ,

         

        when I refer to drag it to the x-axis was exactly what you did to the visualization area and axis. Sorry if I misslead you.

         

        👍