Forum Discussion

vijay_pbi's avatar
vijay_pbi
New Member
2 years ago
Solved

How to show 2weeks data in a column chart

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

 

 

Need Help
  • Joe_Barry's avatar
    Joe_Barry
    2 years ago

    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

1 Reply

  • Joe_Barry's avatar
    Joe_Barry
    Solution Sage
    2 years ago

    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