Dear Power BI community,
I have a historical records of ticket sales in 2019 and 2020 and I hope to see the trends of these sales in a mmm-yyyy format. I have created a column chart, specifically I want to see the trend of the order quantity in months (in the 3rd figure). However, when I drill down my column chart to the months' level, I could not see the year which the ticket is purchased. Additionally, I tried to navigate around the platform but doesn't seem to be able to drill into such the mmm-yyyy format. Does anyone knows how I could change my x axis into such a format? Or could I do such arrangement at the Excel level?
Solved! Go to Solution.
Hi @andrewtan1993 ,
According to your needs, although the "mmmm-yyyy" date field can be customized successfully, it cannot be used on the x-axis of the column chart. You can drill down to the month, and then turn off "Concatenate labels" in the x-axis of the Format, so that the trends of month and year sales can also be displayed visually. Maybe this is the best way.
If the problem is still not resolved, please provide detailed error information and let me know immediately, looking forward to your reply.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
You can use the function "expand all down one level in the hierarchy" option + turn off "concatenate labels" under the filter pane, x-axis formatting options:
(You might need to srot the visual by the date fields once you have turned off the concatenate labels option)
Hi @themistoklis ,
Thank you for your suggestion. I tried using it but came back with this reply. Do you know how I could rectify this?
We are excited to announce the Power BI Super Users!
Featured Session: Drive Data Culture with Power BI- Vision, Strategy & Roadmap. Register here https://myignite.microsoft.com #MSIgnite #PowerPlatform #Power BI
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!
100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.