Forum Discussion
DAX Measure to Detect when Show Next Level is Clicked.
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
Any way to achieve this?
Thanks
2 Replies
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/
Hi Anonymous ,
Can you show me the measure formula you created for the title?
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
