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 ...
Need Help
  • MFelix's avatar
    MFelix
    5 years ago

    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.

     

     

MFelix's avatar
MFelix
Super User
5 years ago

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
    5 years ago

    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
      5 years ago

      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's avatar
        vrv
        Helper II
        5 years ago

        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