Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Would be better if we could see what drill options are available when hovering over the drill button.
Maybe even a dropdown list that is selectable.
Can you clarify this a little more, are you wanting to "jump" hierarchical levels, is that what you are suggesting? So that if you have a hierarchy of:
Geography
Region
Local
You want to start at Geography and be able to jump straight to Local without going through Region?
The drill down really should work like a dropdown picklist so you can choose what you want to drill to.
It would be annoying to have to drill five times to get to the info i wanted to look at each time. Also for new users, they have to remember what they can drill down to and that might keep them from even using the option.
Just a simple UI tweak really. It's like using a slicer but not seeing what's in the slicer and only being able to click next next next next...
I suppose @xxcorpxx means that if you Drill down from Geography -> Netherlands to Regions in Netherlands -> then to Local
i.e Netherlands -> Amsterdam -> Lelylaan , in the tooltip or nowhere you cannot find out what filters ( from where you drill down ), and while from Geography is easy for others is not. Imagine Country - Recruiter - Department - Job Title...Specially when there is overlap between levels ( 1 recruiter can recruit in several countries etc...)
Which brings the problem of cross filtering as @SqlJason blogged which is really confusing to users..
http://www.sqljason.com/2015/09/my-thoughts-on-cross-filtering-in-power.html
Imagime you drill down from my example above from Country to a Recruiter..but this Recruiter also exists in other Country.
What happens is that you see a Recruiter name with i.e. 100 applications in i.e. Netherlands but when you select the bar chart it filters only on recruiter name and the other charts shows different numbers since the first level drill down filter ( Country ) don't pass in the other charts..
Imagine Sales in Countries and products with other charts showing trends..Confusing..
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.