https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Help-with-column-chart-categorization/m-p/3154113#M7199 <P>Hi&nbsp;<a href="https://community.fabric.microsoft.com/t5/user/viewprofilepage/user-id/469025">@LuisM1</a>&nbsp;,<BR />This is completely doable in Power BI by creating calculated measures using DAX code. <BR />Can you provide some sample data so that we can help?</P> <DIV style="border: 1px solid grey; padding: 2px; background-color: #eeeeee;"> <TABLE style="border: none;"> <TBODY> <TR> <TD style="border: none;"><span class="lia-inline-image-display-wrapper" image-alt="PBI_SuperUser_Rank@1x.png" style="width: 73px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/245255iBA79BC16F308A2DA/image-size/large?v=v2&amp;px=999" role="button" title="PBI_SuperUser_Rank@1x.png" alt="PBI_SuperUser_Rank@1x.png" /></span></TD> <TD style="border: none;">&nbsp;</TD> <TD style="border: none;"><BR /><BR /><STRONG><U><MARK style="background-color: #2cabe2;">Give a Thumbs Up</MARK> if this post helped you in any way and <MARK style="background-color: #2cabe2;">Mark This Post as Solution</MARK> if it solved your query !!!</U></STRONG><BR /><BR /><STRONG>Proud To Be a Super User !!!</STRONG><BR /><A style="color: #2cabe2;" href="https://www.linkedin.com/in/anand-radhakrishnan-b97274143" target="_blank" rel="noopener"><STRONG>LinkedIn</STRONG></A><BR /><BR /></TD> </TR> </TBODY> </TABLE> </DIV> Sat, 25 Mar 2023 21:55:32 GMT Anand24 2023-03-25T21:55:32Z https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Help-with-column-chart-categorization/m-p/3148233#M7171 <P>Hi all</P><P>&nbsp;</P><P>Currently i have a survey that runs annualy. At the moment i have the values as % of grand total. I wish to have a % of year total instead.</P><P>&nbsp;</P><P>Is there a way to do this through a measure?</P><P>&nbsp;</P><P>Here is the visual</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="LuisM1_1-1679519988534.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/891326i60AB219EC677424B/image-size/medium?v=v2&amp;px=400" role="button" title="LuisM1_1-1679519988534.png" alt="LuisM1_1-1679519988534.png" /></span></P><P>&nbsp;</P><P>The orange bars should add to 100% and the blue bars should add to 100%</P><P>&nbsp;</P><P>Thank you</P><P>&nbsp;</P> Wed, 22 Mar 2023 21:23:47 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Help-with-column-chart-categorization/m-p/3148233#M7171 LuisM1 2023-03-22T21:23:47Z https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Help-with-column-chart-categorization/m-p/3154113#M7199 <P>Hi&nbsp;<a href="https://community.fabric.microsoft.com/t5/user/viewprofilepage/user-id/469025">@LuisM1</a>&nbsp;,<BR />This is completely doable in Power BI by creating calculated measures using DAX code. <BR />Can you provide some sample data so that we can help?</P> <DIV style="border: 1px solid grey; padding: 2px; background-color: #eeeeee;"> <TABLE style="border: none;"> <TBODY> <TR> <TD style="border: none;"><span class="lia-inline-image-display-wrapper" image-alt="PBI_SuperUser_Rank@1x.png" style="width: 73px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/245255iBA79BC16F308A2DA/image-size/large?v=v2&amp;px=999" role="button" title="PBI_SuperUser_Rank@1x.png" alt="PBI_SuperUser_Rank@1x.png" /></span></TD> <TD style="border: none;">&nbsp;</TD> <TD style="border: none;"><BR /><BR /><STRONG><U><MARK style="background-color: #2cabe2;">Give a Thumbs Up</MARK> if this post helped you in any way and <MARK style="background-color: #2cabe2;">Mark This Post as Solution</MARK> if it solved your query !!!</U></STRONG><BR /><BR /><STRONG>Proud To Be a Super User !!!</STRONG><BR /><A style="color: #2cabe2;" href="https://www.linkedin.com/in/anand-radhakrishnan-b97274143" target="_blank" rel="noopener"><STRONG>LinkedIn</STRONG></A><BR /><BR /></TD> </TR> </TBODY> </TABLE> </DIV> Sat, 25 Mar 2023 21:55:32 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Help-with-column-chart-categorization/m-p/3154113#M7199 Anand24 2023-03-25T21:55:32Z