Forum Discussion
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 list of year will be displayed. The list of year will depend on the entries in the table, for example Cosnumer 1: in the list of year, 2020 and 2021 will be displayed. Consumer 2: will only display 2021. When the user select a year, all of his/her consumption will be displayed for that year only. Can it be done by not prompting any parameter/s, the user will just search from the slicer and select from the list which is dynamically generated according to the consumer's record?
Thank you in advance!
Well just link the 2 tables and all is good to go.
Creating relationship between tables is part of modeling in Power Bi.
15 Replies
powerbiguy_ ,Can you s sample output in table format?
I am not sure if this is what you mean sir
Not sure either 😀
Can you share a Sample Pbix and tell me what you expect to see!
Hi powerbiguy_
Why would you need Dynamic paramters for this! you can simply get SEARCH visual from the market to use it for search by name consumer and add a slicer for the year to your report
The year part is my problem, It will display all of the consumption in a graph and will just highlight the consumption for that year.
You sound like talking about interactions between Graphs, aren't you? if so try to edit interactions.
