Hello everyone,
I am trying to make a visual that uses stacked area chart which has the average volume per week. The problem is that I have a date table and a column in it to get the week number "=WEEKNUM('Reported Date'[Reported Date]')". Whenever I am using this as an x axis, the type is always at "continuous" (changing it is not possible as it always revert back to continuous) and would put the week of January 2020 to February 2020 at the beginning of the visual followed by the weeks of March 2019 up to the end of December 2019.
I have tried to add an W & FORMAT("YYYY") to make it "W23 2019"(sample) and so on.
I hope you can help me with the solution. I don't really have any formal training with PowerBI. I hope my explanation makes it clear.
Thanks!
I am trying to make a visual that uses stacked area chart which has the average volume per week. The problem is that I have a date table and a column in it to get the week number "=WEEKNUM('Reported Date'[Reported Date]')". Whenever I am using this as an x axis, the type is always at "continuous" (changing it is not possible as it always revert back to continuous) and would put the week of January 2020 to February 2020 at the beginning of the visual followed by the weeks of March 2019 up to the end of December 2019.
I have tried to add an W & FORMAT("YYYY") to make it "W23 2019"(sample) and so on.
I hope you can help me with the solution. I don't really have any formal training with PowerBI. I hope my explanation makes it clear.
Thanks!
