Forum Discussion
Solved
Data validation - dependency hierarchy without creating Data lists
Hi all, I need some help. I have a list of Brokerages and Branches and I am creating a form where the user chooses the Brokerage and then must choose a branch. I only want the branches belonging to ...
Hi HeideDeLange
Of course you can! You can use the SELECTEDVALUE( ) function to get the result of the slicer selection.Test = SELECTEDVALUE('Table'[Brokerage])Put this measure in the card visual to validate the results:
Best Regards,
Jayleny
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi there,
Thanks, I learnt something new today, but the slicers don't work, unless you can help with the next step.
So selecting the data was one thing, then I use the result of the selection in a vlookup to bring back a data point.
Can I reference the slicer selection in a vlookup formula?
That is an MS Excel question - not a PowerBI question.