Drill through doesn't show up on values

[_user42_]

Hi folks,

I'm probably overlooking something simple, but I can't figure out why Drill through isn't working between two tables.

I've exported the data sets and brought them into a blank .pbix to make isolate them and get rid of any history.

The tables and most relevant settings below, would someone please chime in with any insight as to why it's not working?

Also, in my sample data set, I notice that when I import them, the Risk Score field in the Department - Risk Score table isn't auto summarized, but the same field in the second table is summarized. I guess that indicates some kind of difference, but they look the same to me in the data source and the pbix.

I've attached the pbix as well if anyone wants to look.

Dropbox - Sample - Read Only, save locally, data is embedded 

When I left click/right click/hover over any values the Department Scope column in Department - Risk Score, nothing shows up.

[Idrissshatila]

Hello @_user42_ ,

make sure you did set these fields as drill through in the drill through page.

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin

[_user42_]

Thank you for your reply @Idrissshatila, I've updated my post to make things more clear, and I've also attached a link to the file.

I have verified that the field I'm trying to drive through with is in the "target" table's drill through settings, the column the user could drill throm from, the "source" has no fields set.

[Idrissshatila · Accepted solution]

Hello @_user42_ ,

so i've downloaded your test.pbix file and did find a solution.

just have both department scope fields from both tables in the drill through.

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin

[_user42_]

Thank you @Idrissshatila, that was it!

I figured it was something simple. Is that a normal configuration for dt?

[Idrissshatila]

Hello @_user42_ ,

well the normal configuration is to have a table in between that has the department  fields in it and linked to both of tables you have and then drill through through this new field in common.

if you want take a look on the star schema Model and try to implement it on the Modeling you do.https://learn.microsoft.com/en-us/power-bi/guidance/star-schema

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin