Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hi,
How to call parameter inside the table, Could you please help me.
Solved! Go to Solution.
HI @Poojajunnu
your request is unclear, please specify what you mean by parameter, what you mean by calling inside a table
🔗Parameters in Power BI (show measure based on a parameter) – solved link from Microsoft Fabric Community
➡️https://community.fabric.microsoft.com/t5/Service/Parameters-in-Power-BI/m-p/2414024/SOLVED (use a separate table with measure names and slicer) Microsoft Fabric Community
🔗Bind to parameter missing / using dynamic M query parameters
➡️https://community.powerbi.com/t5/Desktop/Bind-to-parameter-is-missing-in-modelling-advanced-properti... (explains how binding works and limitations) Power BI Community
🔗Call two different measure parameters in DAX
➡️https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/call-two-different-measure-parameter... (solution shows how to structure parameter table with group logic) Microsoft Fabric Community
🔗Power BI Edit Parameters (using What-If Parameter)
➡️https://community.fabric.microsoft.com/t5/Power-Query/Power-Bi-Edit-Parameters/m-p/4421411/SOLVED (shows how to use a What-If parameter in report via slicer) Microsoft Fabric Community
You can search the main Power BI forums for more parameter solutions:
➡️https://community.fabric.microsoft.com/t5/Power-BI-forums/ct-p/powerbi
I hope this helps!
If you found this answer helpful:
Mark it as the solution to help others find it faster.
Give it a kudo to show your appreciation!
Thank you for being an awesome community member!
It seems to be that you're trying to call the value of a what-if parameter from a slicer inside a calculated table. If this is the case, unfortunately, calculated tables are not aware of slicer selections so they don't know what value is selected in a slicer. Calculated tables are computed only upon creation, when the underlying data (not a slicer selection) has changed or upon refresh.
Hi @Poojajunnu ,
The answer depends slightly on whether you are in Power Query (M) or DAX, but assuming you want to use a Query Parameter to filter or modify a table in the Power Query Editor, here is how you do it.
Scenario 1: Filtering a Table by a Parameter (The Easy Way) You don't need to write code for this. You can use the UI.
Go to the column you want to filter.
Click the Filter arrow > Text/Number Filters > Equals...
In the dialog box that pops up, click the little "ABC" or "123" icon on the right side of the input box.
Select "Parameter" from the dropdown.
Choose your parameter name. Power BI will automatically write the M code: Table.SelectRows(Source, each ([ColumnName] = MyParameter))
Scenario 2: Adding a Parameter as a New Column If you want to add the parameter value to every row in your table:
Go to Add Column tab > Custom Column.
In the formula box, simply type the exact name of your parameter.
Example Formula: [Revenue] * MyExchangeRateParameter
Power Query treats the parameter as a global variable, so you can call it by name anywhere.
Scenario 3: Inside a Native SQL Query If you are writing a SQL statement in the "Get Data" window: You cannot just type the name. You have to concatenate it into the text string.
Example: "SELECT * FROM Sales WHERE Year = " & Number.ToText(YearParameter)
Let me know which specific scenario you are trying to achieve!
If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.
This response was assisted by AI for translation and formatting purposes.
Hello @Poojajunnu,
We hope you're doing well. Could you please confirm whether your issue has been resolved or if you're still facing challenges? Your update will be valuable to the community and may assist others with similar concerns.
Thank you.
Hello @Poojajunnu,
Hope everything’s going great with you. Just checking in has the issue been resolved or are you still running into problems? Sharing an update can really help others facing the same thing.
Thank you.
Inside how we can pull parameters.
Hi @Poojajunnu,
Thank you for posting your query in the Microsoft Fabric Community Forum.
In Power BI Desktop, you cannot call or reference a Power Query parameter directly inside a data table (in the Fields pane). Parameters are only available in Power Query they cannot be used inside DAX tables or DAX measures.
If you want to use a parameter value inside your model, you must create a DAX table or measure that manually re-creates the value, because parameters do not flow into the DAX engine.
Best regards,
Ganesh Singamshetty.
Hi @Poojajunnu ,
The answer depends slightly on whether you are in Power Query (M) or DAX, but assuming you want to use a Query Parameter to filter or modify a table in the Power Query Editor, here is how you do it.
Scenario 1: Filtering a Table by a Parameter (The Easy Way) You don't need to write code for this. You can use the UI.
Go to the column you want to filter.
Click the Filter arrow > Text/Number Filters > Equals...
In the dialog box that pops up, click the little "ABC" or "123" icon on the right side of the input box.
Select "Parameter" from the dropdown.
Choose your parameter name. Power BI will automatically write the M code: Table.SelectRows(Source, each ([ColumnName] = MyParameter))
Scenario 2: Adding a Parameter as a New Column If you want to add the parameter value to every row in your table:
Go to Add Column tab > Custom Column.
In the formula box, simply type the exact name of your parameter.
Example Formula: [Revenue] * MyExchangeRateParameter
Power Query treats the parameter as a global variable, so you can call it by name anywhere.
Scenario 3: Inside a Native SQL Query If you are writing a SQL statement in the "Get Data" window: You cannot just type the name. You have to concatenate it into the text string.
Example: "SELECT * FROM Sales WHERE Year = " & Number.ToText(YearParameter)
Let me know which specific scenario you are trying to achieve!
If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.
This response was assisted by AI for translation and formatting purposes.
It seems to be that you're trying to call the value of a what-if parameter from a slicer inside a calculated table. If this is the case, unfortunately, calculated tables are not aware of slicer selections so they don't know what value is selected in a slicer. Calculated tables are computed only upon creation, when the underlying data (not a slicer selection) has changed or upon refresh.
Hi @Poojajunnu,
Can you be more specific with you quesation and adding an example for greatly help in understanding the problem
Thanks
To help you correctly call or use a parameter inside a table in Power BI, I first need to know which type of parameter you’re working with. Power BI has several kinds of parameters, and each one behaves differently. Some can be used directly inside visuals, while others only work in Power Query unless you load them into the model manually. Because of this, the solution depends entirely on the parameter type.
The first type is the What-If Parameter. This is created from the Modeling tab, and it automatically creates a new table along with a measure. These parameters can be used inside a table visual or inside DAX measures without any extra steps. If you're using this type, you simply reference the generated measure inside your table.
The second type is the Power Query Parameter. These are created inside Power Query and are usually used for filtering or controlling queries. These parameters do not automatically show up in the report view. If you want to use them inside a table visual or a DAX measure, you must load them into a table first. Otherwise, they cannot be directly called.
There are also Field Parameters, which let you switch between columns or measures dynamically. These are great for interactive visuals, but they still need to be used correctly inside a table visual depending on how they’re structured.
To give you the exact solution and the correct Fabric Community thread that matches your case, I just need you to confirm which parameter type you are using. Once you tell me that, I’ll rewrite everything with the right DAX, steps, and solved community links.
I hope this helps!
If you found this answer helpful:
Mark it as the solution to help others find it faster.
Give it a kudo to show your appreciation!
Thank you for being an awesome community member!
Soure: Different Web Sources.
🔗Parameters in Power BI (show measure based on a parameter) – solved link from Microsoft Fabric Community
➡️https://community.fabric.microsoft.com/t5/Service/Parameters-in-Power-BI/m-p/2414024/SOLVED (use a separate table with measure names and slicer) Microsoft Fabric Community
🔗Bind to parameter missing / using dynamic M query parameters
➡️https://community.powerbi.com/t5/Desktop/Bind-to-parameter-is-missing-in-modelling-advanced-properti... (explains how binding works and limitations) Power BI Community
🔗Call two different measure parameters in DAX
➡️https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/call-two-different-measure-parameter... (solution shows how to structure parameter table with group logic) Microsoft Fabric Community
🔗Power BI Edit Parameters (using What-If Parameter)
➡️https://community.fabric.microsoft.com/t5/Power-Query/Power-Bi-Edit-Parameters/m-p/4421411/SOLVED (shows how to use a What-If parameter in report via slicer) Microsoft Fabric Community
You can search the main Power BI forums for more parameter solutions:
➡️https://community.fabric.microsoft.com/t5/Power-BI-forums/ct-p/powerbi
I hope this helps!
If you found this answer helpful:
Mark it as the solution to help others find it faster.
Give it a kudo to show your appreciation!
Thank you for being an awesome community member!
HI @Poojajunnu
your request is unclear, please specify what you mean by parameter, what you mean by calling inside a table
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 40 | |
| 39 | |
| 34 | |
| 29 | |
| 24 |
| User | Count |
|---|---|
| 122 | |
| 111 | |
| 83 | |
| 69 | |
| 68 |