Forum Discussion

powerbiguy_'s avatar
powerbiguy_
Frequent Visitor
5 years ago
Solved

Dynamic Parameter

I have the following tables:   What I wanted to achieve is that, the user will search for a consumer's name in a slicer (which I already done) as soon as the user selected a name, a lis...
Need Help
  • aj1973's avatar
    aj1973
    5 years ago

    Well just link the 2 tables and all is good to go.

     

    Creating relationship between tables is part of modeling in Power Bi.

     

     

powerbiguy_'s avatar
powerbiguy_
Frequent Visitor
5 years ago

I am not sure if this is what you mean sir

 

aj1973's avatar
aj1973
Community Champion
5 years ago

Not sure either ðŸ˜€

 

Can you share a Sample Pbix and tell me what you expect to see!

 

    • aj1973's avatar
      aj1973
      Community Champion
      5 years ago

      Ok , I got the file.

      First there is not relationship between tables. is the Id and ConcessionaresId are the same IDs?

      where is the problem?

       

      • powerbiguy_'s avatar
        powerbiguy_
        Frequent Visitor
        5 years ago

        Yes, the same Ids.

  • powerbiguy_'s avatar
    powerbiguy_
    Frequent Visitor
    5 years ago

    What I expected to see is that everytime the user will select a consumer, the list of year will be displayed according to the consumption records (example if the record for that consumer starts in 2018 up to the present year then 2018, 2019, 2020 and 2021 will only be shown and lastly graph will only show the consumption for the particular year that the user selected.