Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
powerbiguy_
Frequent 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

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.

@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
Super User

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

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

I am not sure if this is what you mean sir

powerbiguy__0-1618243311203.png

 

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.

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.

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!

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

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

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
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.