How to show 2weeks data in a column chart

[vijay_pbi]

Hi Everyone,

Recently, I came up with a requirement to show a Clustered column chart where x-axis shows 2week period (chart 1). I have used a calender table in powerquery, where i have created a column using Date.StartOfWeek and Date.EndOfWeek.

Now to achieve this requrirement I have created one more column by using Date.AddDays to add 14 days to current end date. When i created a clustered column chart with this new field, it gives 14days range between each column, but the next column start date differs (see chart 2).

May I know your thoughts to fix this ?

Requirement -Chart1

Wrong chart - chart2

[Joe_Barry · Accepted solution]

Hi @vijay_pbi 

The new column needs to be numerically sorted. You will need to create another column where each new two week period has a numericaly sort number. Then when you load this you will need to sort the two week column by the sort column.

I would suggest for the sort column create a column that shows the start date of the two week period and use this for sorting

Thanks

Joe

If you found my answer helpful and it solved your issue, please accept as solution