https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Group-Month-by-Qtr/m-p/2917360#M6256 <P>Hi&nbsp;<a href="https://community.fabric.microsoft.com/t5/user/viewprofilepage/user-id/202311">@BeaBF</a>&nbsp;. I grouped the month using this solution:</P><P>&nbsp;</P><P><A href="https://community.powerbi.com/t5/Desktop/How-to-display-quarter-Months-name-Axis/td-p/1875694" target="_blank">https://community.powerbi.com/t5/Desktop/How-to-display-quarter-Months-name-Axis/td-p/1875694</A></P><P>&nbsp;</P><P>After that, I create new column and use IFELSE formula to rename July-Sep to Q1 (fiscal year) etc. As for ELSE, I return the original month name. The result came out like this</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Power bi Question.PNG" style="width: 469px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/826431iACEF145592DE63B1/image-dimensions/469x170?v=v2" width="469" height="170" role="button" title="Power bi Question.PNG" alt="Power bi Question.PNG" /></span></P> Mon, 21 Nov 2022 01:30:54 GMT Aqil_Shah 2022-11-21T01:30:54Z https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Group-Month-by-Qtr/m-p/2905011#M6218 <P>Hello,</P><P>&nbsp;</P><P>I have spend data for each months. So, I want to display the charts by quarter. However, I want to display month individually if the month for the quarter is incomplete. I attached the drawing on how my visual should looks like. It is possible to do? Thanks!</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Power bi Question.PNG" style="width: 769px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/822902iEC207A08227B2FAF/image-size/large?v=v2&amp;px=999" role="button" title="Power bi Question.PNG" alt="Power bi Question.PNG" /></span></P> Tue, 15 Nov 2022 01:40:37 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Group-Month-by-Qtr/m-p/2905011#M6218 Aqil_Shah 2022-11-15T01:40:37Z https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Group-Month-by-Qtr/m-p/2912776#M6236 <P><a href="https://community.fabric.microsoft.com/t5/user/viewprofilepage/user-id/471818">@Aqil_Shah</a>&nbsp;Hi! Can you attack the pbix? it needs a calculated column/measure</P> <P>&nbsp;</P> <P>BBF</P> Thu, 17 Nov 2022 13:23:50 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Group-Month-by-Qtr/m-p/2912776#M6236 BeaBF 2022-11-17T13:23:50Z https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Group-Month-by-Qtr/m-p/2917360#M6256 <P>Hi&nbsp;<a href="https://community.fabric.microsoft.com/t5/user/viewprofilepage/user-id/202311">@BeaBF</a>&nbsp;. I grouped the month using this solution:</P><P>&nbsp;</P><P><A href="https://community.powerbi.com/t5/Desktop/How-to-display-quarter-Months-name-Axis/td-p/1875694" target="_blank">https://community.powerbi.com/t5/Desktop/How-to-display-quarter-Months-name-Axis/td-p/1875694</A></P><P>&nbsp;</P><P>After that, I create new column and use IFELSE formula to rename July-Sep to Q1 (fiscal year) etc. As for ELSE, I return the original month name. The result came out like this</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Power bi Question.PNG" style="width: 469px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/826431iACEF145592DE63B1/image-dimensions/469x170?v=v2" width="469" height="170" role="button" title="Power bi Question.PNG" alt="Power bi Question.PNG" /></span></P> Mon, 21 Nov 2022 01:30:54 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Group-Month-by-Qtr/m-p/2917360#M6256 Aqil_Shah 2022-11-21T01:30:54Z