Group Month by Qtr

[Aqil_Shah]

Hello,

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!

[BeaBF]

@Aqil_Shah Hi! Can you attack the pbix? it needs a calculated column/measure

BBF

[Aqil_Shah · Accepted solution]

Hi @BeaBF . I grouped the month using this solution:

https://community.powerbi.com/t5/Desktop/How-to-display-quarter-Months-name-Axis/td-p/1875694

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