Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more
Hi,
Can someone please advise on how I can exclude these kind of data lines, especially if the duration goes beyond 17:00 mins?
I have used the duration filter, but I still see this line on my view. Any idea?
= Table.SelectRows(#"Sorted Rows", each [Duration] < #duration(0, 0, 17, 0))
Extract the minutes on a different column, type it as whole number and then use that column to filter < 17
Proud to be a Super User!
 
					
				
				
			
		
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
 
            | User | Count | 
|---|---|
| 87 | |
| 49 | |
| 36 | |
| 31 | |
| 30 |