Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Best practice tips for multi-level data design for PowerBI?

Hi all,    I have a data-set with relationships that is best described with the following example:   When a user installs an app, a unique user-id is generated.  Each time the user uses the app,...
  • v-kelly-msft's avatar
    6 years ago

    Hi Anonymous ,

     

    In my opinion, you can split your report into several pages according to your “level” requirement, the first page contains all summarized data of your report and other pages can contain different details, you can just stay in the first page ,when you need to get the detailed information ,you can use “drill through” function to get to certain detail you need. ”Drill through” will be linked to the page which contains the details you need.

     

    You can turn to the URL for more information: https://docs.microsoft.com/en-us/power-bi/desktop-drillthrough

     

    Hope it would help.

     

    Best Regards,

    Kelly