cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
powerbiguy_
Regular Visitor

Dynamic Parameter

I have the following tables:

powerbiguy__0-1618239412745.png

powerbiguy__1-1618239451136.png

 

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! 

 

1 ACCEPTED SOLUTION
aj1973
Community Champion
Community Champion

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

aj1973_0-1618246282702.png

 

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

 

 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

View solution in original post

15 REPLIES 15
aj1973
Community Champion
Community Champion

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

 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

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.

aj1973
Community Champion
Community Champion

@powerbiguy_ 

You sound like talking about interactions between Graphs, aren't you? if so try to edit interactions.

 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

amitchandak
Super User IV
Super User IV

@powerbiguy_ ,Can you s sample output in table format?



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

I am not sure if this is what you mean sir

powerbiguy__0-1618243311203.png

 

aj1973
Community Champion
Community Champion

Not sure either 😀

 

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

 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

powerbiguy__0-1618245209407.png

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.

aj1973
Community Champion
Community Champion

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?

 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

Yes, the same Ids.

aj1973
Community Champion
Community Champion

is this what you want to see?

aj1973_0-1618246000361.png

 

 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

Yes sir, that's it!

aj1973
Community Champion
Community Champion

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

aj1973_0-1618246282702.png

 

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

 

 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

View solution in original post

Thank you for your time and patience! I really appreciate all your help!

aj1973
Community Champion
Community Champion

Welcome

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Top Solution Authors
Top Kudoed Authors