Forum Discussion

MarkNoordraven's avatar
MarkNoordraven
Frequent Visitor
7 years ago

How to get a MMM-formatted X-axis with week-level data granularity, without aggregating to month?

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:                    ...
Need Help
v-yuta-msft's avatar
v-yuta-msft
Icon for Community Support rankCommunity Support
7 years ago

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

MarkNoordraven's avatar
MarkNoordraven
Frequent Visitor
7 years ago

Thank you Jimmy for looking into my question.

 

  • It appears formatting into date results in an error.

 

  • Summing Value seems to result in the months in the axis shifting around, but not yet following chronological order.

 

If it helps, please find below the .pbix file used in these examples: https://we.tl/t-VtukT8XB1x