Showing empty in parent row for the text column of child ion drill down

[jobrock]

Hi ,

I am using matrix visual with drill down to four level.

The publication title column  is corresponding to the fourth level. So data in it should show only when I expand the last child but as can be seen in the pic column has data for even parent rows. I don't understand how is it getting the data, It should be blank. Can any one please point me where I am making the mistake.

The columns are values. Please see the screenshot below

Any help would be appreciable.

Thank you

[v-piga-msft]

Hi @jobrock ,

In matrix, the values will be aggregated. 

For your scenario, I'm afraid that the parent rows show the aggregated value in child level.

If you still need help, please share the dummy pbix file which can reproduce the scenario, so that we can help further investigate on it? You can upload it to OneDrive and post the link here. Do mask sensitive data before uploading.

Best  Regards,

Cherry

[jobrock · Accepted solution]

Hi,

Thankyou for your response, I found a solution for this.

[Anonymous]

Hi! is it possible to share the solution you found? I would also like to apply this is our report. thanks!