Sorting grouped weeks in chart

[Anonymous]

I am trying to sort the chart with the grouped weeks so it starts with the lowest and ends with >12, but somehow this isnt possible

when i select sort by weeks i get the this result - it should start with 2-4, 4-6, 6-8........

[richbenmintz · Accepted solution]

I just created a really simple pbix and modeled a sort by column and the result is as you would expect, see image. the lnk below is for the pbix file

https://1drv.ms/u/s!AhCeuF2piSWMgb9zmQ2MdHx87T-Zig

[Anonymous]

I had selected the wrong column for when selecting sort by - i guess it helped to have a weekend thanks for helping 🙂

[Anonymous]

I have the weeks groups in Weeks and then sort column by Order By but still it looks like this 😕

[richbenmintz]

can you share your pbix file, I am sure there is something not quite right

[Anonymous]

I'll need to create a dummy file - it will take a while, but i will send it as soon as possible, thanks 🙂

[richbenmintz]

have you assigned a sort by column to the weeks attribute in your model?

[Anonymous]

yes, but no effect