Dynamic Drill through columns based on selection in a visual

[Anonymous]

Hi,

Fairly new to Power BI and I am trying to build a drill through capability where I am able to select and display the columns based on what I pre-select in my visual. So basically I have 3 categories of measures that are basically percentages calculations plotted against 'month' parameter on the x-axis. I have also created a drill through sheet with columns.

Step 1: Select measure category in a visual. This dynamically plots the % measure on a visual - DONE

Step 2: I select a particular value against a month --> right click --> Drill through --> Go to the details view.

Here, I need to dynamically display the numerator and denominator that goes in the % calculation for the selected measure category in Step 1. I need this to be a dynamically selected numerator/ denominator column since every measure category has a different numerator and denominator column. 

My question: Is there a way to dynamically select the pair of numerator and denominator based on the measure category I select in the previous step? OR is there a way to dynamically set the column header values based on the category selection?

[Greg_Deckler]

@Anonymous - I am having trouble visualizing what you are trying to do. Can you post your PBIX file or maybe some screen shots? It's hard to puzzle out from your description only.