Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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.
@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.
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
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.
Hi @Anonymous
You can move the start date on top of end date in the Values container of the Matrix visual.
Hello,
my values are only from the column - Submission time -hour
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |