Choose One Value in Graph to see All Values in another Table

[novotnajk]

Trying again to see if giving sample data helps.

Below is a medical file table and a pharmacy table in Power BI Query.  What I'm trying to do is the following:

1)  If I click on Acute Suppurative Otitis Media (as an example), I want to have a graph show me the pharmacy claims for anyone with that condition.

2)  Conversely, if I click on Levothyroxine in the Pharmacy graph, I want a medical graph to show me all medical conditions for individuals taking Levothyroxine.

A patient may show up many times in each file due to the reporting date and their various diagnoses.  Any help?  Getting desperate! 🙂

Medical File

Pharmacy File

[novotnajk]

@v-piga-msft 

Hi!

Thanks for the suggestion, but the two tables aren't related except for the Patient ID, so I can't drill down to a medication from a diagnosis because there is nothing in common except the patient.  Do you know how a drilldown would work using a Patient ID and all of their diagnoses and prescriptions?

[v-piga-msft]

Hi @novotnajk ,

For your scenario, I think use Drill through feature in power bi should be a good choice.

Please refer to this document firstly about how to use Drill through.

If you need further help, please share some data sample as table format so that we could have a test on it.

Best  Regards,

Cherry