cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Reorder the column in a matrix

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

matrix2.PNGmatrix.PNG

 
 
6 REPLIES 6
Highlighted
Super User IV
Super User IV

Re: Reorder the column in a matrix

Hi @alexmateiu 

 

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

image.png

Best Regards,
Mariusz

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

Please feel free to connect with me.
LinkedIn

 

Highlighted
Helper I
Helper I

Re: Reorder the column in a matrix

Hello,

 

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

 matrix3.PNG

Highlighted
Super User IV
Super User IV

Re: Reorder the column in a matrix

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.



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
My Recent Blog -Week is not so Weak Connect on Linkedin

Proud to be a Super User!

Highlighted
Helper I
Helper I

Re: Reorder the column in a matrix

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

matrix4.PNG

Highlighted
Super User IV
Super User IV

Re: Reorder the column in a matrix

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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
My Recent Blog -Week is not so Weak Connect on Linkedin

Proud to be a Super User!

Highlighted
Helper I
Helper I

Re: Reorder the column in a matrix

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.

matrix5.PNG

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

July 2020 Community Highlights

July 2020 Community Highlights

Learn about the exciting things that happened in July.

Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

We are thrilled to announce we will begin running a monthly webinar series named Power BI Dev Camp.

Top Solution Authors
Top Kudoed Authors