Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
---|---|
102 | |
91 | |
85 | |
77 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
75 | |
64 |