Time in slicer

Thanks for following up. If displaying the time with a dot or colon (like 08:30 or 08.30) inside the slicer is a must, here's the best workaround given Power BI's current limitations:

You can still use the TimeInMinutes (or a decimal field) for the slicer logic, but pair it with a display column that shows the time in the format you need. Here's how you can do it:

TimeDecimal = HOUR([YourTimeColumn]) + MINUTE([YourTimeColumn]) / 60
TimeLabel = FORMAT([YourTimeColumn], "HH:mm")

 If your locale forces a comma in TimeDecimal, and you just need the label to show a dot or colon, create a custom label column:

TimeLabelDot = SUBSTITUTE(TimeLabel, ":", ".")

Then use a custom slicer visual (like Smart Filter by OKViz or HierarchySlicer) that lets you show labels but filter using the underlying value.

Power BI's built-in slicer doesn’t support formatted display with separate logic, so using a custom visual is the most flexible option here.

Best Regards,

Hammad.