Forum Discussion
drill down based on legends
No one gets it :).
I created for this a second custom table with an unpivot on those 4 columns and a relationship with the ID between them. Then 1 Chiclet slicer for the unpivotted table and 4 'classic slicers'.
But yes, I'm quite curious if there is an easier way for my end users to get a drill down on legend.
I would love this also, would be very powerful.
This is the closest workaround I could do so far (x-axis should be named legend, I know). But still, if you wanted to pin it for just 1 of the types, you have to click an option of a 'normal' slicer and then hit the subtype option. I've created something similar for the y-axis as well so it would be completely flexible.
My problem so far is, it is fancy, but mainly used for data exploring to see how different section are related to each other. This is generally done by those who already know how Power BI works. And as soon as you find the consistency, you pin that consistency against the wall and the dynamic drill down is no longer required.
Perhaps when I get to the sales numbers instead of KPI's, that this might become interesting.
Like this:
Then use 'Table 2'[Filter] for the column required in a filter visual.
Can you walk through how you created this?
worked great, thanks
Top!
I'm just missing a real life application for this. The only really useful things I've found is if you want to mess around with the data as a user.
It has great life application
I am facing the same issue with composite Index evolution over time
I wanna see evolution of composite index in Y and time in X, but i want to be able to drill down the subcategories of my composite index:
click on the graph it shows the evolution of the three main categories over time
click on one main categories it shoes me the evolution of the variable it is composed of (over time in X)
Value is the same (measure called value who does sort of an average)
