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.
Photo1
data has start of hour listed after each datapoint
Photo2
I've selected Time and Transform -> Hour -> Start of hour
Photo3
Selected slicer and correct data
Photo4
Slicer Gives me some dates (which don't really affect anyway), but I not (Hours of 0:00:00-23:00:00 )Times...
On the top I've tried to explain the problem. I can use the filter settings on page/report level, but for some reason this Slicer is not so intuative as you could hope when it comes to time. Altough the date slicer is great!
Thank you for excellent software! Its awesome!
Solved! Go to Solution.
Hi @AndyMan,
Currently, the Slicer does't support Time Slicer at time-level. Here is a similar idea shared on Power BI Ideas. You can vote it up and add your comments there to make this feature coming sooner.
In addition, if you only want to use Hours of 0:00:00-23:00:00 as Slicer on your report, you should be able to use the formula below to create new calculate column in your Time table, then show it as a Slicer.
TimeText = FORMAT ( 'Time'[Time], "hh:mm:ss" )
Regards
Hi @AndyMan,
Currently, the Slicer does't support Time Slicer at time-level. Here is a similar idea shared on Power BI Ideas. You can vote it up and add your comments there to make this feature coming sooner.
In addition, if you only want to use Hours of 0:00:00-23:00:00 as Slicer on your report, you should be able to use the formula below to create new calculate column in your Time table, then show it as a Slicer.
TimeText = FORMAT ( 'Time'[Time], "hh:mm:ss" )
Regards
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |