cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
wwcnd Member
Member

Sorting grouped weeks in chart

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

 

week 2.JPG

 

1 ACCEPTED SOLUTION

Accepted Solutions
richbenmintz
Advisor

Re: Sorting grouped weeks in chart

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

 

Screen Shot 2016-11-25 at 8.28.16 AM.png

View solution in original post

7 REPLIES 7
richbenmintz
Advisor

Re: Sorting grouped weeks in chart

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

wwcnd Member
Member

Re: Sorting grouped weeks in chart

yes, but no effect
richbenmintz
Advisor

Re: Sorting grouped weeks in chart

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

 

Screen Shot 2016-11-25 at 8.28.16 AM.png

View solution in original post

wwcnd Member
Member

Re: Sorting grouped weeks in chart

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

 

grp1.JPGsort.JPGchart.JPG

richbenmintz
Advisor

Re: Sorting grouped weeks in chart

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

wwcnd Member
Member

Re: Sorting grouped weeks in chart

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

Re: Sorting grouped weeks in chart

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

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)