Forum Discussion
2 Level X Axis Format for Fiscal Qtr/Year
Hello All,
I have data at a Fiscal Qtr/Year level(sample below) and I want to build a trend with the fiscal period on the x-axis with Quarter on Top and Fiscal Year beneath that.
The problem I'm facing is PowerBI is repeating the years across each data point. I split the fiscal period into Quarter and Year and tried using Heirarchies as I turned off the "CONCATENATE LABELS" option but that didn't help either.
| Fiscal Period | Revenue |
| FY2020Q1 | 152,991 |
| FY2020Q2 | 116,537 |
| FY2020Q3 | 195,037 |
| FY2020Q4 | 166,201 |
| FY2021Q1 | 145,556 |
| FY2021Q2 | 193,280 |
| FY2021Q3 | 153,872 |
| FY2021Q4 | 104,067 |
Current Outcome:
Current and Desired Outcome
Desired Outcome:
Anonymous I just tested and it worked, make sure sorting in the visual is by A->Z and by Fiscal Year
✨ Follow us on LinkedIn
Learn about conditional formatting at Microsoft Reactor
My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
1 Reply
- parry2k
Super User
Anonymous I just tested and it worked, make sure sorting in the visual is by A->Z and by Fiscal Year
✨ Follow us on LinkedIn
Learn about conditional formatting at Microsoft Reactor
My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡