DAX Measure to Detect when Show Next Level is Clicked.

[Anonymous]

Hi All,

I have a bar chart with a 2 level hierarchy on the X Axis. The visual title changes dynamically based on the which level the X axis is on,using the selected value function (default value is for top level of the hierarchy). This works perfectly when I use the Expand to Next Level Option, but not on the Show Next Level Option.
Any way to achieve this?

Thanks

[v-lionel-msft]

Hi @Anonymous ,

Can you show me the measure formula you created for the title?

Best regards,
Lionel Chen

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

[amitchandak]

@Anonymous , Can share formula and explain with an example. Are you using isinscope or isfiltered

refer these two

https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/

https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/