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.
Hello,,
Thank you for your support and reply,
Please could you help me to calculate reporting interactionID per timeslot by using the column Call end time:
06h-07h
07h-08h
08h-09h
09h-10h
10h-11h
11h-12h
12h-13h
13h-14h
14h-15h
15h-16h
16h-17h
17h-18h
Solved! Go to Solution.
Is this what you want?
timeslot = HOUR('Table'[call end time])&"h-"&(HOUR('Table'[call end time])+1)&"h"
Proud to be a Super User!
right click the column in the value filed to change to count
Click three dot on the top right of your chart, choose sort by time slot and click sort by asc or des to show in order.
Proud to be a Super User!
Is this what you want?
timeslot = HOUR('Table'[call end time])&"h-"&(HOUR('Table'[call end time])+1)&"h"
Proud to be a Super User!
Thanks a lot RYAN, this is exactly what i want, this is below the result i just want to show that from 06h till 18h in chronological order, is this anything i need to add?
maybe try
column=
var timeslot = HOUR('Table'[call end time])&"h-"&(HOUR('Table'[call end time])+1)&"h"
RETURN IF (HOUR('Table'[call end time])>=6&& HOUR('Table'[call end time])<=17), timeslot, "")
Proud to be a Super User!
Something goes wrong, please advise?
please try remove the closed bracket after number 17
Proud to be a Super User!
i tried again, KO
Please advise
please take a look at this.
Column =
VAR timeslot = HOUR('Table (2)'[callendtime])&"h-"&(HOUR('Table (2)'[callendtime])+1)&"h"
return if(HOUR('Table (2)'[callendtime])>=6 && HOUR('Table (2)'[callendtime])<=17, timeslot,"")
Proud to be a Super User!
I have done exactly what you said, but the result in chart should be:
from 06h-07h till 17h18
and not to depend to how many hours taken!
Could you please create a chart in excel to show the expected output that you want?
Proud to be a Super User!
I have a data base of entered like this one below with a column named "Call end time":
i want to do a chart like this one below that respect chronological order from 06h-07h till 17h-18h, and count how many entered by slot, like you see below:
please created a column that I mentioned.
put any column in the value field and change to count
unselected blank value in timeslot
Proud to be a Super User!
where to find to change it to count,
please take a look and tell me if this is what you asked exactly, the slot still not organized chronogicaly ?
right click the column in the value filed to change to count
Click three dot on the top right of your chart, choose sort by time slot and click sort by asc or des to show in order.
Proud to be a Super User!
Hi @ayoubb ,
See if this solution helps
https://community.powerbi.com/t5/Desktop/How-to-Create-24-rows-for-hour-of-day/td-p/764523
Regards,
Harsh Nathani
No i'm afraid i don't have this in a different column, i want to recover that from "Call end time"
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 |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |