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 col...
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

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