Forum Discussion

AndyMan's avatar
AndyMan
New Member
9 years ago
Solved

Slicer with time

  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   ...
Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    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.:smileyhappy:

     

    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.:smileyhappy:

    TimeText = FORMAT ( 'Time'[Time], "hh:mm:ss" )

     

    Regards

v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
9 years ago

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.:smileyhappy:

 

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.:smileyhappy:

TimeText = FORMAT ( 'Time'[Time], "hh:mm:ss" )

 

Regards