drill down by date and user

[vrv]

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

[MFelix · Accepted solution]

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]

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]

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.

👍

[vrv]

Thank you again, Miguel!

Sorry, this is really my frst report with Power BI. I can get very easily confused and it is nobody's fault.

I accepted your answer as solution.

Regards,

vv