Forum Discussion
Helper IIDisplay the drill down level in a visual ?
By no way I find a way to display the drill down level of a visual (eg country, state,city in treemaps or bubble chart) !
If a box in a treemap or a bubble or even multiple elements are selected, it's possible to build something with IsFiltered and show a measure in a card or even in the header...
But if nothing is chosen would anyone know a trick to solve this issue ???
By my googling activities, I've found some requests dating back to 2015, some posts around 2018, but no positive answers !?
4 Replies
- amitchandak
Super User
marcl1 , The information you have provided is not making the problem clear to me. Can you please explain with an example.
Appreciate your Kudos.isfiltered and isinscope can help, but need is not very clear
https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/
https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/
marcl1
As you can see in this bubble chart i've 3 levels of hierarchy (country group soldto): how can i say "you're looking at the group view"
- v-luwang-msft
Community Support
Hi marcl1 ,
You could try to use drillthrough button
And I find an article is similar to your question ,you could have a look:
How to Add a Drill Down Filter to See Which Level of the Hierarchy You're Seeing:https://community.powerbi.com/t5/Desktop/How-to-Add-a-Drill-Down-Filter-to-See-Which-Level-of-the/td-p/1056992
Wish it is helpful for you!
Best Regards
Lucien
- v-luwang-msft
Hi marcl1 ,
Has your problem been solved, if so, please consider Accept a correct reply as the solution to help others find it.Best RegardsLucien
