https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/dynamically-changing-pie-chart/m-p/3488353#M8151 <P>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:</P><P>&nbsp;</P><TABLE border="1"><TBODY><TR><TD>Name</TD><TD>val1</TD><TD><P>val2</P></TD><TD>val3</TD><TD>val4</TD><TD>sum</TD></TR><TR><TD>xxx</TD><TD>1</TD><TD>2</TD><TD>3</TD><TD>4</TD><TD>10</TD></TR><TR><TD>yyy</TD><TD>4</TD><TD>1</TD><TD>3</TD><TD>5</TD><TD>13</TD></TR><TR><TD>zzz</TD><TD>3</TD><TD>3</TD><TD>2</TD><TD>1</TD><TD>9</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Based on this example, I would like to see what percentage of the sum for "name" are val1,val2,val2.&nbsp;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.</P> Fri, 20 Oct 2023 17:49:25 GMT Asturn15 2023-10-20T17:49:25Z https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/dynamically-changing-pie-chart/m-p/3488353#M8151 <P>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:</P><P>&nbsp;</P><TABLE border="1"><TBODY><TR><TD>Name</TD><TD>val1</TD><TD><P>val2</P></TD><TD>val3</TD><TD>val4</TD><TD>sum</TD></TR><TR><TD>xxx</TD><TD>1</TD><TD>2</TD><TD>3</TD><TD>4</TD><TD>10</TD></TR><TR><TD>yyy</TD><TD>4</TD><TD>1</TD><TD>3</TD><TD>5</TD><TD>13</TD></TR><TR><TD>zzz</TD><TD>3</TD><TD>3</TD><TD>2</TD><TD>1</TD><TD>9</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Based on this example, I would like to see what percentage of the sum for "name" are val1,val2,val2.&nbsp;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.</P> Fri, 20 Oct 2023 17:49:25 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/dynamically-changing-pie-chart/m-p/3488353#M8151 Asturn15 2023-10-20T17:49:25Z https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/dynamically-changing-pie-chart/m-p/3490030#M8174 <P>First step is to unpivot your data to make it usable in Power BI.&nbsp; Then your visuals work all by themselves.</P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="lbendlin_0-1698015816830.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/984664iCADA3A63BF21FFA7/image-size/medium?v=v2&amp;px=400" role="button" title="lbendlin_0-1698015816830.png" alt="lbendlin_0-1698015816830.png" /></span></P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> Sun, 22 Oct 2023 23:04:20 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/dynamically-changing-pie-chart/m-p/3490030#M8174 lbendlin 2023-10-22T23:04:20Z