Forum Discussion
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
- vrvHelper 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