Dynamic Title + hierarchie levels

[Anonymous]

I am trying to make a dynamic title, but this only works for the first layer in the hierarchie of the visual. The title will change if in one of the filters the value 1 is selected. In the first level the opportunitys are by owner.

Sample: If you select "1" in the filter this week, then the title changes to "Opportunity this week by owner"

Link to sample pbix

Problem:

Currently it is showing Opportunitys by Owner in all hierarchies

Goal:

So i want the dynamic title to work between different hierarchie showing:

-In the hierarchie level of owner: opportunitys by Owner

-In the hierarchie level of Createdby: opportunitys by createdby

-In the hierarchie level of Team: opportunitys by Team

And I want the title to work with the filters, so it shows

- Opportunitys by ... this week

-Opportunitys by ... previous week

-Opportunitys by ... this month

-Opportunitys by ... previous month

Question:

Is it possible to check the current hierarchie level? I tried with isinscope(), but this won't work when it's used in the title). Or does someone have an other solution?

[v-yuta-msft]

@Anonymous ,

Have you tried path() and pathitem() ? In your senario, you could build several additional columns to achieve the hierarchy level.

Reference:

https://powerpivotpro.com/2018/09/using-dax-to-handle-multiple-parent-hierarchies/

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Tried, but I can't get it working.