Dynamic percentage calculation in a table with parameters

[erhanunal]

Hi everyone, I have one question even if i try some solution could not handle it. I have one parameter table with 3 field and this visual. I created this table with show value with function but I would like to change it to with my parameters value. For example, when i choose cost , i hope to see the percentage of cost for each year for each item type. How can i do that? Best regards

[Tahreem24 · Accepted solution]

@erhanunal You can use "Field Parameter" feature for dynamically change the field values as per selection made. Refer this blog and YouTube video:

https://www.sqlbi.com/articles/fields-parameters-in-power-bi/
https://www.youtube.com/watch?v=Gkuq0jTAKj4