Reorder the column in a matrix

[Anonymous]

Hey guys,

I have a quick question regarding the order of the columns in a matrix.

I have the below matrix and would like to have Start Time before End Time...how can I do this the easiest way? 

Below also the structure of my table

[amitchandak]

Create measures like this

end time calculate(max(table[submission time]), table[Action]="End time")
Start time calculate(max(table[submission time]), table[Action]="Start time")

On matrix row use Name of requestor and On col use month and day from date.

[Anonymous]

@amitchandak  works as intended, however I would prefer to only have the hour in the value section...it is rather redundend since I have the day in the column headers.

[amitchandak]

You can use .time

of format([timestamp],"hh")

like format end time = format([end time],"hh:mm")

or

end time = calculate(max(table[submission time].time), table[Action]="End time")
Start time= calculate(max(table[submission time].time), table[Action]="Start time")

or

end time =calculate(max(table[submission time]), table[Action]="End time").time
Start time =calculate(max(table[submission time]), table[Action]="Start time").time

[Anonymous]

Looks like it's getting closer. I managed to format the result to only show the hour and minutes but now the matrix isn't showing the only dates I want - I have a relative filter to only show last 2 days.

[Mariusz]

Hi @Anonymous 

You can move the start date on top of end date in the Values container of the Matrix visual.

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

[Anonymous]

Hello,

my values are only from the column - Submission time -hour