Blank when drilling down in chart

[Anonymous]

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 ?

[v-caliao-msft · Accepted solution]

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]

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