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!
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
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
Helpful resources
Power BI T-Shirt Design Challenge 2023
Vote for your favorite t-shirt design now through March 28.
March 2023 Events
Find out more about the online and in person events happening in March!
