Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Poojajunnu
Frequent Visitor

How to call parameter inside the table

Hi,


How to call parameter inside the table, Could you please help me.

4 ACCEPTED SOLUTIONS
FBergamaschi
Solution Sage
Solution Sage

HI @Poojajunnu 

your request is unclear, please specify what you mean by parameter, what you mean by calling inside a table

 

 

View solution in original post

123abc
Community Champion
Community Champion

Solved Community Threads

🔗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


🔍Additional Community Related Resources

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!

View solution in original post

danextian
Super User
Super User

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.





Dane Belarmino | Microsoft MVP | Proud to be a Super User!

Did I answer your question? Mark my post as a solution!


"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.

View solution in original post

burakkaragoz
Community Champion
Community Champion

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.

  1. Go to the column you want to filter.

  2. Click the Filter arrow > Text/Number Filters > Equals...

  3. In the dialog box that pops up, click the little "ABC" or "123" icon on the right side of the input box.

  4. Select "Parameter" from the dropdown.

  5. 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:

  1. Go to Add Column tab > Custom Column.

  2. In the formula box, simply type the exact name of your parameter.

    • Example Formula: [Revenue] * MyExchangeRateParameter

  3. 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.

View solution in original post

10 REPLIES 10
v-ssriganesh
Community Support
Community Support

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.

v-ssriganesh
Community Support
Community Support

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.

 

Poojajunnu
Frequent Visitor

Poojajunnu_0-1765516493293.png

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.


burakkaragoz
Community Champion
Community Champion

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.

  1. Go to the column you want to filter.

  2. Click the Filter arrow > Text/Number Filters > Equals...

  3. In the dialog box that pops up, click the little "ABC" or "123" icon on the right side of the input box.

  4. Select "Parameter" from the dropdown.

  5. 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:

  1. Go to Add Column tab > Custom Column.

  2. In the formula box, simply type the exact name of your parameter.

    • Example Formula: [Revenue] * MyExchangeRateParameter

  3. 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.

danextian
Super User
Super User

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.





Dane Belarmino | Microsoft MVP | Proud to be a Super User!

Did I answer your question? Mark my post as a solution!


"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.
Abhilash_P
Impactful Individual
Impactful Individual

Hi @Poojajunnu,

Can you be more specific with you quesation and adding an example for greatly help in understanding the problem

Thanks 

123abc
Community Champion
Community Champion

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.

123abc
Community Champion
Community Champion

Solved Community Threads

🔗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


🔍Additional Community Related Resources

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!

FBergamaschi
Solution Sage
Solution Sage

HI @Poojajunnu 

your request is unclear, please specify what you mean by parameter, what you mean by calling inside a table

 

 

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.