Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Detailed Data

I have a matrix report where data is being shown from multiple sources. Drill through is not working properly in this case and the requirement is to show the corresponding records from the matrix. ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

hi v-lili6-msft 

Please have a look at the below image-

 

I have created different table for differeent dataset on different pages.

 

SO this way after doing a right click for drill through, it will give all options for drill through.

 

There should be only one option and not multiple. 

v-lili6-msft's avatar
v-lili6-msft
Community Support
5 years ago

hi  Anonymous 

In power bi, there will be only multiple option and not only one, as i said above, you use IF/SWITCH Function to custom judge which dataset should show in current row context, but power bi couldn't identify this logic.

If this way, I would suggest you rename each page name by each dataset name that help users to understand it well.

 

 

Regards,

Lin