Forum Discussion
How to set the Parameter value during data load?
Hello I have a dataset S: Col1 Col2 A 1 B 2 C 3 And I have a parameter TestPar (not required, any type) During data load I want to set TestPar = 2 (value Col2 when ...
Hi az38
You may go to 'Manage Parameters' to set and use it in query editor.Below is the article about it.
https://powerbi.microsoft.com/en-us/blog/deep-dive-into-query-parameters-and-power-bi-templates/
Regards,
Cherie
- Hi, thnx, but it's not the same what I need. I need to remember somewhere (Parameter for example) value from the particular cell then remove row with this cell then show this value in the Report
There is a good solution to create new column and fill it https://community.powerbi.com/t5/Desktop/Get-data-from-single-cell-in-DataSet-M-Language/m-p/625782#M298911
But what if i don't want to create new column and want to store value from the cell somewhere
