Matrix with multiple individual parameters

Edit_Streit · ‎07-20-2023

Dear Community,

I need some help with a dynamic matrix request, hope you can help.

My client would like to have a table with multiple cell-level type-in fields and some calculations that would be based on the actual values of these type-in fields. I guess parameters would be the right choice here. Is there a way that I can avoid adding them one by one? Here is a simplified example of what is needed but I have way more products in reality and they keep changing with all report updates, thus, I would prefer to have an automated paremeter solution.

Thank you very much in advance for your kind help!

Edit

v-stephen-msft · ‎07-24-2023

Hi @Edit_Streit ,

Try incremental refresh. You can specify that part of your data source be refreshed. This also means that you need to modify the input data in the data source.

Incremental refresh for datasets and real-time data in Power BI - Power BI | Microsoft Learn

If the data is simple, try creating several what-if parameters and selecting the values that clients want as they interact with the report.

Use parameters to visualize variables - Power BI | Microsoft Learn

Best Regards,

Stephen Tao

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