Forum Discussion
Anonymous
9 years agoNot applicable
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
Microsoft 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
- AnonymousNot applicablehi 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