Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
@Anonymous
Use that expression to create a calculated column in the table instead of a measure
Proud to be a Super User!
Paul on Linkedin.
Hi @Anonymous ,
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.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous
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)
Proud to be a Super User!
Paul on Linkedin.
@Anonymous
You can create a new column with this format.
See formula below:
Month-Year = FORMAT(Table[Date], "MMM-YYYY")
And use this column on x axis
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?
@Anonymous
Use that expression to create a calculated column in the table instead of a measure
Proud to be a Super User!
Paul on Linkedin.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |