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
New to Fabric Survey
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
Power BI DataViz World Championships - June 2026
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Join our Fabric User Panel
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
Power BI Community Update - March 2026
Check out the March 2026 Power BI update to learn about new features.
