Forum Discussion
Helper IHi, I want to create a dynamic table based on user parameter selection.
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?
eg
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)
can you please share a pbix file for this? so the parameter table can take user input with different values for different products?
6 Replies
- lbendlin
Super User
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.
- Kedar_Pande
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.
Pra2010Ghacan you please share a pbix file for this? so the parameter table can take user input with different values for different products?
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
- RufydaSpoiler
Microsoft Learn References
RELATED function → https://learn.microsoft.com/en-us/dax/related-function-dax
Create relationships in Power BI → https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-create-and-manage-relationships
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
