10. Parameters in Power Query (and Other Kinds of Parameters)
10.9 What-if Parameters and Field Parameters Are Different
| Power Query parameter | What-if parameter | Field parameter | |
|---|---|---|---|
| Created in | Power Query (Manage Parameters) | Modeling › New parameter › Numeric range | Modeling › New parameter › Fields |
| Changes | Which data is loaded (at refresh) | A number used in DAX at query time (slicer) | Which measure/column a visual shows |
| Viewer can change it in the report? | No (the author or dataset owner changes it) | Yes, with a slicer | Yes, with a slicer |
| Example | ServerName, FolderPath, StartDate | Delivery Fee Change % | Switch Sales / Orders / AOV |
| Covered in | This module | Module 21 | Module 21 |
Practice task
Create FolderPath, StartDate and SelectedCity (list from a query) parameters. Use them to load fakt one city's orders from 01-04-2025 (start of the Indian financial year). Export the report as a .pbit and open it punha to test the parameter prompts.
Ravindra Bagale's Tip
Mitrano, khup students mix up the three kinds of "parameters" in interviews. Power Query parameters control data loading, what-if parameters create a number slicer for scenarios, and field parameters switch measures or fields in visuals. Name the right one in your answer. Practice kara, mag ekdum sope vatel.
Thodkyaat sangaycha tar (quick recap)
Path, server aani dates parameters madhe theva, type barobar nivda, rename karnyaadhi Query Dependencies (अवलंबित्वे) bagha, aani Power Query, what-if aani field parameters madhla farak lakshat theva. Aata pudhe jaauya – data modelling!