topic Re: Hi, I want to create a dynamic table based on user parameter selection. in DAX Commands and Tips

Hi, I want to create a dynamic table based on user parameter selection.

Pra2010Gha — Wed, 22 Oct 2025 18:59:42 GMT

In my backend table there are products and thier base price. the user will provide a parameter value (discount which varies for each product) and The calculated Selling Price is = base price * selected parameter value(discount).Now if i enter the parameter value it takes same value for all products but I want an out put where there are multiple products entered and different parameter values.Is that possible?

Product base Price

TV 1000

fridge 250

now the out put I want is

Product Base Price Parameter Value (discount ) Selling Price

TV 1000 5% discount 950(1000*.95)

fridge 250 2 % discount 245 (250*.98)

Re: Hi, I want to create a dynamic table based on user parameter selection.

lbendlin — Thu, 23 Oct 2025 00:23:10 GMT

Not yet possible in standard Power BI. In Fabric they slowly move towards that with UDFs and Translytical Task Flows.

There may be (paid) third party visuals that support that.

Re: Hi, I want to create a dynamic table based on user parameter selection.

Kedar_Pande — Thu, 23 Oct 2025 12:28:45 GMT

Create a separate parameter table with products and their discount rates. Use that table in a many-to-one relationship with your products table.

Then create a calculated column:

Selling Price = 'Products'[Base Price] * (1 - 'Parameter Table'[Discount])

This allows different discount rates per product.

Re: Hi, I want to create a dynamic table based on user parameter selection.

Pra2010Gha — Thu, 23 Oct 2025 15:01:31 GMT

can you please share a pbix file for this? so the parameter table can take user input with different values for different products?

Re: Hi, I want to create a dynamic table based on user parameter selection.

Anonymous — Mon, 27 Oct 2025 08:30:53 GMT

Hi Pra2010Gha,

Thank you for reaching out to the Microsoft Fabric Forum Community, and special thanks to lbendlin and Kedar_Pande for prompt and helpful responses.

As mentioned by the lbendlin this functionality is not currently possible in standard Power BI. Parameters apply the same value across all rows, so assigning different parameter values per product isn’t supported yet.

Thanks & Regards,

Prasanna Kumar

Re: Hi, I want to create a dynamic table based on user parameter selection.

Rufyda — Mon, 27 Oct 2025 13:37:27 GMT

Microsoft Learn References

Create relationships in Power BI → https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-create-and-manage-relationships

Re: Hi, I want to create a dynamic table based on user parameter selection.

Anonymous — Fri, 31 Oct 2025 03:12:59 GMT

Hi Pra2010Gha,

Just following up to see if the Response provided by community members were helpful in addressing the issue. if the issue still persists Feel free to reach out if you need any further clarification or assistance.

Best regards,
Prasanna Kumar