Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
@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.
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |