Forum Discussion

HeideDeLange's avatar
HeideDeLange
Regular Visitor
1 year ago
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 ...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    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.

  • HeideDeLange's avatar
    HeideDeLange
    Regular Visitor
    1 year ago

    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?

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      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.

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      1 year ago

      That is an MS Excel question - not  a PowerBI question.