Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have time data of 24 hours need to show only data recored between 8 am to 6 pm in line graph.
im using time(Bin), but i want to exclude data not between specified time line.
Raw Data
Date | Time | Result |
01-Mar-22 | 2:01 AM | 24 |
01-Mar-22 | 2:11 AM | 24 |
01-Mar-22 | 2:21 AM | 23.9 |
01-Mar-22 | 2:31 AM | 24 |
01-Mar-22 | 2:41 AM | 24 |
01-Mar-22 | 2:51 AM | 23.9 |
01-Mar-22 | 3:01 AM | 23.9 |
01-Mar-22 | 3:11 AM | 24 |
01-Mar-22 | 3:21 AM | 24 |
01-Mar-22 | 3:31 AM | 24 |
01-Mar-22 | 3:41 AM | 24 |
01-Mar-22 | 3:51 AM | 24 |
01-Mar-22 | 4:01 AM | 23.9 |
01-Mar-22 | 4:11 AM | 23.9 |
01-Mar-22 | 4:21 AM | 23.9 |
01-Mar-22 | 4:31 AM | 24 |
01-Mar-22 | 4:41 AM | 24 |
01-Mar-22 | 4:51 AM | 24 |
01-Mar-22 | 5:01 AM | 24 |
01-Mar-22 | 5:11 AM | 23.9 |
01-Mar-22 | 5:21 AM | 24 |
01-Mar-22 | 5:31 AM | 24 |
01-Mar-22 | 5:41 AM | 23.9 |
01-Mar-22 | 5:51 AM | 24 |
01-Mar-22 | 6:01 AM | 24 |
01-Mar-22 | 6:11 AM | 23.8 |
01-Mar-22 | 6:21 AM | 23.9 |
01-Mar-22 | 6:31 AM | 23.8 |
01-Mar-22 | 6:41 AM | 23.9 |
01-Mar-22 | 6:51 AM | 23.9 |
01-Mar-22 | 7:01 AM | 23.9 |
01-Mar-22 | 7:11 AM | 23.8 |
01-Mar-22 | 7:21 AM | 23.9 |
01-Mar-22 | 7:31 AM | 23.8 |
01-Mar-22 | 7:41 AM | 23.8 |
01-Mar-22 | 7:51 AM | 23.8 |
01-Mar-22 | 8:01 AM | 23.9 |
01-Mar-22 | 8:11 AM | 23.8 |
01-Mar-22 | 8:21 AM | 23.8 |
01-Mar-22 | 8:31 AM | 23.8 |
01-Mar-22 | 8:41 AM | 23.8 |
01-Mar-22 | 8:51 AM | 23.8 |
01-Mar-22 | 9:01 AM | 23.8 |
01-Mar-22 | 9:11 AM | 23.9 |
01-Mar-22 | 9:21 AM | 24 |
01-Mar-22 | 9:31 AM | 24 |
01-Mar-22 | 9:41 AM | 24 |
01-Mar-22 | 9:51 AM | 24.1 |
01-Mar-22 | 10:01 AM | 24.2 |
01-Mar-22 | 10:11 AM | 24.2 |
01-Mar-22 | 10:21 AM | 24.4 |
01-Mar-22 | 10:31 AM | 24.2 |
01-Mar-22 | 10:41 AM | 24.3 |
01-Mar-22 | 10:51 AM | 24.3 |
01-Mar-22 | 11:01 AM | 24.4 |
01-Mar-22 | 11:11 AM | 24.3 |
01-Mar-22 | 11:21 AM | 24.3 |
01-Mar-22 | 11:31 AM | 24.3 |
01-Mar-22 | 11:41 AM | 24.4 |
01-Mar-22 | 11:51 AM | 24.4 |
01-Mar-22 | 12:01 PM | 24.5 |
01-Mar-22 | 12:11 PM | 24.4 |
01-Mar-22 | 12:21 PM | 24.3 |
01-Mar-22 | 12:31 PM | 24.4 |
01-Mar-22 | 12:41 PM | 24.4 |
01-Mar-22 | 12:51 PM | 24.3 |
01-Mar-22 | 1:01 PM | 24.4 |
01-Mar-22 | 1:11 PM | 24.4 |
01-Mar-22 | 1:21 PM | 24.3 |
01-Mar-22 | 1:31 PM | 24.4 |
01-Mar-22 | 1:41 PM | 24.4 |
01-Mar-22 | 1:51 PM | 24.4 |
01-Mar-22 | 2:01 PM | 24.4 |
01-Mar-22 | 2:11 PM | 24.6 |
01-Mar-22 | 2:21 PM | 24.4 |
01-Mar-22 | 2:31 PM | 24.4 |
01-Mar-22 | 2:41 PM | 24.4 |
01-Mar-22 | 2:51 PM | 24.4 |
01-Mar-22 | 3:01 PM | 24.6 |
01-Mar-22 | 3:11 PM | 24.4 |
01-Mar-22 | 3:21 PM | 24.4 |
01-Mar-22 | 3:31 PM | 24.4 |
01-Mar-22 | 3:41 PM | 24.6 |
01-Mar-22 | 3:51 PM | 24.5 |
01-Mar-22 | 4:01 PM | 24.5 |
01-Mar-22 | 4:11 PM | 24.5 |
01-Mar-22 | 4:21 PM | 24.6 |
01-Mar-22 | 4:31 PM | 24.6 |
01-Mar-22 | 4:41 PM | 24.6 |
01-Mar-22 | 4:51 PM | 24.6 |
01-Mar-22 | 5:01 PM | 24.6 |
01-Mar-22 | 5:11 PM | 24.5 |
01-Mar-22 | 5:21 PM | 24.6 |
01-Mar-22 | 5:31 PM | 24.7 |
01-Mar-22 | 5:41 PM | 24.4 |
01-Mar-22 | 5:51 PM | 24.6 |
01-Mar-22 | 6:01 PM | 24.6 |
01-Mar-22 | 6:11 PM | 24.6 |
01-Mar-22 | 6:21 PM | 24.6 |
01-Mar-22 | 6:31 PM | 24.6 |
01-Mar-22 | 6:41 PM | 24.5 |
01-Mar-22 | 6:51 PM | 24.6 |
01-Mar-22 | 7:01 PM | 24.6 |
01-Mar-22 | 7:11 PM | 24.7 |
01-Mar-22 | 7:21 PM | 24.5 |
01-Mar-22 | 7:31 PM | 24.7 |
01-Mar-22 | 7:41 PM | 24.7 |
01-Mar-22 | 7:51 PM | 24.6 |
01-Mar-22 | 8:01 PM | 24.7 |
01-Mar-22 | 8:11 PM | 24.7 |
01-Mar-22 | 8:21 PM | 24.7 |
01-Mar-22 | 8:31 PM | 24.7 |
01-Mar-22 | 8:41 PM | 24.7 |
01-Mar-22 | 8:51 PM | 24.7 |
Solved! Go to Solution.
Hi @Rohit_23 ,
Please try to apply this measure to the visual level filter:
Flag =
IF(SELECTEDVALUE('Table'[Time])>=TIME(8,0,0)&&SELECTEDVALUE('Table'[Time])<=TIME(18,0,0),1,0)
Final output:
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Rohit_23 ,
Please try to apply this measure to the visual level filter:
Flag =
IF(SELECTEDVALUE('Table'[Time])>=TIME(8,0,0)&&SELECTEDVALUE('Table'[Time])<=TIME(18,0,0),1,0)
Final output:
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
109 | |
102 | |
86 | |
77 | |
69 |
User | Count |
---|---|
120 | |
110 | |
95 | |
82 | |
77 |