Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Blank when drilling down in chart

I have an issue with see the data when drilling down I have 1 table with data, e.g. case number, actions etc. lets call it main_Data then i have 1 with employee and then another with organization info and there is a relationship between Organization and Employee and a relationship between Employee and main_Data table then i make a measure on cases without actions and - show it on a chart and i like to drill see the departments on different level and at the end drill down to the name of the employee. I select the organization levels from the Organization table and employee name from the main_Data table Unforutnatly all i get is blank on organization I have cheched on a person and it is all there Did anyone else experince this ?
  • Hi Anonymous,

     

    I have tested it on my local environment, we can create a drill down report if we set the relationship properly.

    Sample table


    Report design

     

    If this is not what you want, please provide us more detail information and some sample data. so that we can make further analysis.

     

    Regards,

    Charlie Liao

     

2 Replies

  • v-caliao-msft's avatar
    v-caliao-msft
    Icon for Microsoft Employee rankMicrosoft Employee

    Hi Anonymous,

     

    I have tested it on my local environment, we can create a drill down report if we set the relationship properly.

    Sample table


    Report design

     

    If this is not what you want, please provide us more detail information and some sample data. so that we can make further analysis.

     

    Regards,

    Charlie Liao

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      hi Charlie True, it works well now - actually i thought it was possible to have relationship from 2 tables to another, but apprently its only one of them that can be active and this caused the problem. selma