Start of Hour Showing Date on Card

[Maureen]

 I have start of the hour as a variable that I tried to use as a drill-though variable.    But when I select 9:00AM on a graph and drill though to a card, it shows the time and a dummy date that I do not want.  My variable is set as  time variable.  Any suggestions on how I can make the card show time-only?

[aj1973]

Hi @Maureen 

One of the best parctices in Power BI is to *** Split date and time *** for better performance

https://powerbi.microsoft.com/en-us/blog/best-practice-rules-to-improve-your-models-performance/

I suggest you add a new column for Time and use it in your card

[Maureen]

This column was already set up as  a "start of the hour" column from the query editor and shows as only a time variable, not date/time  Is it still necessary to split even though it shows as time only?

[aj1973]

I would say yes and try it if you prefer to see the exact time in your card.

[mahoneypat · Accepted solution]

In DAX, times also have that hidden data value (and Dates have a hidden time value of midnight).  You can wrap it in format to show your desired format (or choose a format in the ribbon).

TimeFormat = Format(MIN(Table[TimeColumn]), "hh:mm:ss AM/PM")

Pat