Forum Discussion
Dynamic percentage calculation in a table with parameters
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
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
1 Reply
- Tahreem24
Super User
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