Forum Discussion
Dynamic Dimension Drill down
Hi,
I have created a matrix with dynamic dimension using the technique mentioned in the below article:
http://www.leanx.eu/tutorials/dynamic-dimensions-in-power-bi
Further I want to be able to select multiple dimension (upto 3) and drill down the matrix. I am facing issues when dimension 2 and dimension 3 are blank. It returns all the values of the dimension. I want the following functionality:
1. If no value selected for dim 2 and dim 3 - No values should be appended to the dimension row.
2.. If a value is selected for dim 2/dim 3 - The matrix should drill down to that dimension.
Regards,
Maanav Doshi
2 Replies
dustinnResolver I
You mean it will automatically drill down the visual when you select the combination on your filter?
if yes, then I'm only thinking of 2 workarounds:
1. Use bookmark but this would mean you'll be creating a bunch of buttons/charts for each combination.
2. Create a new columns which appends your dimension 1&2 and dimension 1&3 then add it on your join table then modify the measure to check if 2 filter values are selected. Though the problem with this one is that you just have straight text for the axis.
Hi,
Sorry for being unclear about the problem. I want to be able to select dim 2 and dim 3 and the matrix should have them as drill down. If nothing is selected in dim 2 and dim 3 then no drill down. Currently I have 3 calculated columns (selected value of dimension slicer) for 3 dimension slicers. If dim 2 and dim 3 are blank, it throws garbage value.
Regards,
Maanav Doshi.