Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi all,
I've got a table with 2 columns, values and weekly dates. Plotting it into a line chart and removing the date hierarchy results in the following chart:
What I'd like to do is change the X-axis format to "MMM" instead of the current "Mmm YYYY", while retaining the weekly tooltips as in current example and while retaining the weekly character of the line.
Things I tried:
Challenges I run into:
Hi MarkNoordraven,
Click format-> X axis and change continuous to categorical type.
Regards,
Jimmy Tao
Hi Jimmy,
Thank you for your response.
The proposed solution doesn't appear to work for me unfortunately, because of these reasons:
- The line turns into a monthly line in which each point on the chart is an average of the underlying weeks in the month.
- The months are sorted in an inappropriate order.
When I try to change the order in the Modeling tab, I get the following error:
Hi MarkNoordraven,
Change "Average of Value" to "Sum of Value" in the value field.
In addtion, the sort of date is decided by first alphanumeric when the value is text type, so you should change text type to date type.
Regards,
Jimmy Tao
Thank you Jimmy for looking into my question.
If it helps, please find below the .pbix file used in these examples: https://we.tl/t-VtukT8XB1x
User | Count |
---|---|
140 | |
113 | |
104 | |
76 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |