Matrix with multiple individual parameters

Question

Dear Community,&nbsp;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.&nbsp;&nbsp;Thank you very much in advance for your kind help!Edit&nbsp;

foodd · Answer

How to Get Your Question Answered Quickly &nbsp;

anonymous · Answer

Hi&nbsp;Anonymous&nbsp;,
&nbsp;
Try incremental refresh.&nbsp;You can specify that part of your data source be refreshed.&nbsp;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
&nbsp;
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
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
Best Regards,
Stephen Tao
&nbsp;
If this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;

Forum Discussion

Matrix with multiple individual parameters

2 Replies

Related content

Matrix behaviour multiple parameters

Field Parameters - Individual Filters

Sum dynamic parameter fields multiple selected parameter

Parameter slicer with measure for multiple columns

Parameter in summarize