Forum Discussion

Jarodp42's avatar
Jarodp42
Frequent Visitor
6 years ago
Solved

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.

 

 

Need Help
  • v-joesh-msft's avatar
    v-joesh-msft
    6 years ago

    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.

     

4 Replies

    • Jarodp42's avatar
      Jarodp42
      Frequent Visitor
      6 years ago

       

      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? 

      • v-joesh-msft's avatar
        v-joesh-msft
        Solution Sage
        6 years ago

        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.