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 September 2023 Update
Take a look at the September 2023 Power BI update to learn more.
Exclusive opportunity for Women!
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
Power Platform Conference-Power BI and Fabric Sessions
Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.
