Forum Discussion

MouserMike's avatar
MouserMike
Helper I
6 years ago
Solved

Sort report by name then date

 I created a report to be used with Project Online that includes resource names and task assignments.  I want to sort the report first by the name, then the task (assignment) start date.  I've read s...
Need Help
v-lili6-msft's avatar
v-lili6-msft
Community Support
6 years ago

hi, MouserMike 

First, you should know that Difference between custom column and calculated column, please refer to this post:

https://community.powerbi.com/t5/Desktop/Difference-between-custom-column-and-calculated-column/td-p/71591

 

Second, from your formula we could know that this is a calculated column.

so you could add FORMAT Function in your formula to change the format to output.

New Sort = Assignments[ResourceName] & FORMAT ( Assignments[AssignmentStartDate].[Date], "yyyy/mm/dd" )

Result:

 

Best Regards,

lin

MouserMike's avatar
MouserMike
Helper I
6 years ago

I have the sorting working correctly using the calculated column in the visual:

New Sort = Assignments[ResourceName] & FORMAT ( Assignments[AssignmentStartDate].[Date], "yyyy/mm/dd" )

However, I really don't want this column to be visible in the visual; the individual columns are already there, and this calculated column looks rather weird since it's multiple columns concatenated together.  I've looked for ways to sort a visual by a column that is not part of the visual, but the only "solution" I've found is to add this calculated column to the far right of the visual, then shrink the width so it's almost invisible.  Is there another way to do this?