Time slicer in PowerBI

Question

This is sample of values appearing in my time custom column:

Part of formula that generated this custom column goes like this:

RETURN FORMAT( TIME(hr; mn;ss); "HH:mm:ss" ))

so this column suppose to be in "time" format.

But in visuals this column is recognized as text with discrete values. Is there a way to define it as time and use it as slicer/filter which is time based?

Answer 1

In the modeling tab, make sure the data type for your calculated column is set to 'Time'.