Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
marcl1
Helper II
Helper II

Display 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 4
v-luwang-msft
Community Support
Community Support

Hi @marcl1 ,

Has your problem been solved, if so, please consider Accept a correct reply as the solution to help others find it.
 
Best Regards
Lucien
v-luwang-msft
Community Support
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... 

 

Wish it is helpful for you!

Best Regards

Lucien

amitchandak
Super User
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/

 

2021-05-03_19-35-48.jpg


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"

Helpful resources

Announcements
PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.