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 Monthly Update - November 2023
Check out the November 2023 Power BI update to learn about new features.
Fabric Community News unified experience
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
The largest Power BI and Fabric virtual conference
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.
