cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Jarodp42
Frequent Visitor

Parameters, matrix & measures (Need Help)

I am trying to build a dynamic calculator inside Power BI using multiple parameters. Is there a way to create a dynamic dashboard that will allow the user to filter the names they want in the table and have it calculate the fields using the parameters specific to each name in the table? Any ideas are greatly appreciated.

FYI, I know how to create parameters, but when using them it calculates the entire table using the same parameters. I need the parameters to be row specific, so I can calculate each row with different parameters.

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
v-joesh-msft Solution Sage
Solution Sage

Re: Parameters, matrix & measures (Need Help)

Hi @Jarodp42 ,

After my research, I'm afraid it couldn't achieve in Power BI for now. For your requirement, you could post your new idea in Power BI ideas and make this feature coming sooner.
https://ideas.powerbi.com/forums/265200-power-bi-ideas

 

Best Regards,

Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

View solution in original post

4 REPLIES 4
v-joesh-msft Solution Sage
Solution Sage

Re: Parameters, matrix & measures (Need Help)

Hi @Jarodp42 ,

I am not sure if I understand what you mean, this video may be helpful: Populate a Power BI parameter list using a query

Best Regards,

Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Jarodp42
Frequent Visitor

Re: Parameters, matrix & measures (Need Help)

Capture.JPG

 

Hi, @v-joesh-msft thanks for responding to my post. To make it a little more clear on what I am trying to accomplish, I have posted a pic for a visual understanding. As you can see from the pic, the dropdowns are the parameters that I am wanting to base my measures on. However, I am unable to figure out how to use multiple parameters within the same table or matrix. I would like to have different parameters for each language pair in my table/matrix. (Not sure if a table or matrix would be best to use) Is there a way to make a parameter row specific inside a table/matrix?

 

For example, English -> China could have 9 cases, 6725 words, 24.7% leverage with a rate of $.125 while English -> Japan could have 15 cases, 3000 words, 30.2% leverage with a rate of $.150 and so on depending on how many language pairs I am looking to use in my table. How would I be able to use parameters and measure to calculate it so each language pair calculates using their specific parameters? 

Highlighted
v-joesh-msft Solution Sage
Solution Sage

Re: Parameters, matrix & measures (Need Help)

Hi @Jarodp42 ,

After my research, I'm afraid it couldn't achieve in Power BI for now. For your requirement, you could post your new idea in Power BI ideas and make this feature coming sooner.
https://ideas.powerbi.com/forums/265200-power-bi-ideas

 

Best Regards,

Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

View solution in original post

Jarodp42
Frequent Visitor

Re: Parameters, matrix & measures (Need Help)

Thank you for your response @v-joesh-msft After the research that I had done as well I wasn't able to complete the task I was hoping to accomplish. I appreciate your time and effort in helping me.

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors