dynamically changing pie chart

[Asturn15]

I want to build a pie chart in which I can find the percentage of a specific value. Not the sum of all the values ​​in this column, but the number from another column. Below is an example:

Name	val1	val2	val3	val4	sum
xxx	1	2	3	4	10
yyy	4	1	3	5	13
zzz	3	3	2	1	9

Based on this example, I would like to see what percentage of the sum for "name" are val1,val2,val2. I know I can easily calculate it, but I would like to build a chart in which these values ​​will change dynamically depending on the "name" filter.

[lbendlin]

First step is to unpivot your data to make it usable in Power BI.  Then your visuals work all by themselves.