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

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi v-lili6-msft ,

     

    Thanks you for your suggestion.

    I am proceeding that way however the problem I am facing here is, it's working for measures but not for calculated columns.

     

    Isn't is supposed to work for calculated columns?

     

    Like, according to my sample pbix, it works for SubCategory 1 (assuming it to be a measure) however not working for Sub Category 2 (measure derived from a calculated column).

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi v-lili6-msft , 

     

    Any way of doing it?