topic Stacked Bar Chart - Help in Developer https://community.fabric.microsoft.com/t5/Developer/Stacked-Bar-Chart-Help/m-p/3925965#M52603 <P class="lia-align-left">Hi,</P><P class="lia-align-left">&nbsp;</P><P class="lia-align-left">I am trying to create a Stacked Column chart like below, I am not able to get it right. Any suggestions ?</P><P class="lia-align-left">Below chart should honour the selections based on Project or other dimensions. Another point how do we add Total on top of Bar and % of each value.</P><P class="lia-align-left">&nbsp;</P><P class="lia-align-left">Sample Data</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>Project</TD><TD>Type</TD><TD>Budget</TD><TD>Forecast</TD><TD>Actual</TD></TR><TR><TD>P1</TD><TD>PROD</TD><TD>100</TD><TD>100</TD><TD>50</TD></TR><TR><TD>P2</TD><TD>SERV</TD><TD>150</TD><TD>150</TD><TD>25</TD></TR><TR><TD>P3</TD><TD>SERV</TD><TD>100</TD><TD>100</TD><TD>45</TD></TR><TR><TD>P4</TD><TD>SERV</TD><TD>250</TD><TD>250</TD><TD>25</TD></TR><TR><TD>P5</TD><TD>PROD</TD><TD>100</TD><TD>100</TD><TD>60</TD></TR><TR><TD>P6</TD><TD>PROD</TD><TD>120</TD><TD>120</TD><TD>80</TD></TR><TR><TD>P7</TD><TD>PROD</TD><TD>250</TD><TD>250</TD><TD>150</TD></TR><TR><TD>P8</TD><TD>PROD</TD><TD>200</TD><TD>200</TD><TD>90</TD></TR></TBODY></TABLE><P class="lia-align-left">Output</P><P><img /></P><P>&nbsp;</P> Fri, 17 May 2024 06:30:41 GMT manojk_pbi 2024-05-17T06:30:41Z Stacked Bar Chart - Help https://community.fabric.microsoft.com/t5/Developer/Stacked-Bar-Chart-Help/m-p/3925965#M52603 <P class="lia-align-left">Hi,</P><P class="lia-align-left">&nbsp;</P><P class="lia-align-left">I am trying to create a Stacked Column chart like below, I am not able to get it right. Any suggestions ?</P><P class="lia-align-left">Below chart should honour the selections based on Project or other dimensions. Another point how do we add Total on top of Bar and % of each value.</P><P class="lia-align-left">&nbsp;</P><P class="lia-align-left">Sample Data</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>Project</TD><TD>Type</TD><TD>Budget</TD><TD>Forecast</TD><TD>Actual</TD></TR><TR><TD>P1</TD><TD>PROD</TD><TD>100</TD><TD>100</TD><TD>50</TD></TR><TR><TD>P2</TD><TD>SERV</TD><TD>150</TD><TD>150</TD><TD>25</TD></TR><TR><TD>P3</TD><TD>SERV</TD><TD>100</TD><TD>100</TD><TD>45</TD></TR><TR><TD>P4</TD><TD>SERV</TD><TD>250</TD><TD>250</TD><TD>25</TD></TR><TR><TD>P5</TD><TD>PROD</TD><TD>100</TD><TD>100</TD><TD>60</TD></TR><TR><TD>P6</TD><TD>PROD</TD><TD>120</TD><TD>120</TD><TD>80</TD></TR><TR><TD>P7</TD><TD>PROD</TD><TD>250</TD><TD>250</TD><TD>150</TD></TR><TR><TD>P8</TD><TD>PROD</TD><TD>200</TD><TD>200</TD><TD>90</TD></TR></TBODY></TABLE><P class="lia-align-left">Output</P><P><img /></P><P>&nbsp;</P> Fri, 17 May 2024 06:30:41 GMT https://community.fabric.microsoft.com/t5/Developer/Stacked-Bar-Chart-Help/m-p/3925965#M52603 manojk_pbi 2024-05-17T06:30:41Z Re: Stacked Bar Chart - Help https://community.fabric.microsoft.com/t5/Developer/Stacked-Bar-Chart-Help/m-p/3927685#M52624 <P>Your data is not in a usable format. Unpivot it.</P> <P>&nbsp;</P> <P><img /></P> <P>Then enable Totals labels</P> <P><img /></P> <P>Then create a percentage measure and add it to the Detail area</P> <P><img /></P> <P>&nbsp;</P> <P>Careful, you risk trying to do too much. Make sure your users understand the visual.</P> <P>&nbsp;</P> <P>&nbsp;</P> Fri, 17 May 2024 13:38:24 GMT https://community.fabric.microsoft.com/t5/Developer/Stacked-Bar-Chart-Help/m-p/3927685#M52624 lbendlin 2024-05-17T13:38:24Z Re: Stacked Bar Chart - Help https://community.fabric.microsoft.com/t5/Developer/Stacked-Bar-Chart-Help/m-p/3931326#M52665 <P>Thanks&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="100342" data-lia-user-login="lbendlin" class="lia-mention lia-mention-user">lbendlin</a>&nbsp; for the solution. This is exactly what i am looking.&nbsp;</P><P>&nbsp;</P> Mon, 20 May 2024 05:52:01 GMT https://community.fabric.microsoft.com/t5/Developer/Stacked-Bar-Chart-Help/m-p/3931326#M52665 manojk_pbi 2024-05-20T05:52:01Z