cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Responsive Resident
Responsive Resident

Position in drill-down hierarchy of a visual in the absence of row context?

I know how to use ISINSCOPE to establish where I'm at within a hierarchy in a matrix visual that has row context. However, in some visuals such as maps, there's no row context for ISINSCOPE to work. Is there any way I may I missed to know, say, whether I'm at the country/state/county level of a map visual? I need this to be able to do dynamic titles, measures etc.

3 REPLIES 3
Highlighted
Super User VII
Super User VII

Re: Position in drill-down hierarchy of a visual in the absence of row context?

@otravers try HASONEFILTER function.






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Highlighted
Responsive Resident
Responsive Resident

Re: Position in drill-down hierarchy of a visual in the absence of row context?

@parry2k thanks for your reply. HASONEFILTER does work for "Click to turn on Drill Down", as in the following example, which indeed is better than ISINSCOPE for my use case:

 

drill-down.png

 

However what I was really after is to capture where I'm at in the hierarchy after I've clicked on "Go to the next level in the hierarchy." I can see how my question was phrased ambiguously. The following example shows that the map is not generating a new filter context for HASONEFILTER to work against:

 

drill-down-next-level.png

 

(These screenshots are taken with the Mapbox custom visual but the default Map visual behaves similarly.)

 

So, to rephrase my inquiry, I'm looking for a way to capture in DAX the fact of going to the next level of a hierarchy without drilling down to a specific value of the parent hierarchy, for instance going to counties from states while still showing all states.

Highlighted
Helper I
Helper I

Re: Position in drill-down hierarchy of a visual in the absence of row context?

@otravers - were you ever able to figure out how to get this to work?

 

I am trying to get a dynamic title for a chart based on the level of a hierarchy that has been drilled down to. 

Any other method as ISINSCOPE doesn't seem to work for this. 

Helpful resources

Announcements
Meet the 2020 Season 2 Power BI Super Users!

Meet the 2020 Season 2 Power BI Super Users!

Find out who's part of the program this season, and welcome the new Super Users.

August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

July 2020 Community Highlights

July 2020 Community Highlights

Learn about the exciting things that happened in July.

Featured Data Story of The Month

Featured Data Story of The Month

All Data Stories Gallery contributions are reviewed for each month. We select a contribution and feature the community member the following month.

Power BI Dev Camp - Developing with .NET Core

Power BI Dev Camp - Developing with .NET Core

Learn how to develop custom web applications for Power BI using .NET Core 3.1 and .NET 5.

Top Solution Authors