Dataflows - format object as time with format HH:MM

[po]

Hi,

New to dataflows and have changed column to be of type Time which means when use dataflow in a dataset shows as HH:MM:SS

How can we set the time format on a column in power query (dataflow) to be of format HH:MM so that anybody consuming this column in a dataset does not need to format n the datasest itself?

Also in datasets we can change the display of a table to have several sub-folders so we can group the columns in individual sub-folders.

Is it possible for a table in dataflows to have sub-folders and how can we best achieve this in power query/dataflows?

Thanks

[jennratten]

Hello - you can change the appearance of the time in the dataflow by tranforming like this (:

= Table.AddColumn(#"Previous Step", "HHmm", each DateTime.ToText([#"Date - Copy"], "HH:mm"), type time)

'Grouping columns into subfolders' - I think you are referring to creating hierarchies.  This cannot be done in Power Query. The closest thing would be to have a dimension table that includes the hierarchies and then relate that table to the fact table.  You would still have to create the hierarchies in the data model though.

[po]

Hi,

Thanks for reply.

Do you need to create a separate time column?

e.g. if just wanted to have date_created itself formatted as HH:MM is this possible?

Not meaning hierarchies as such, just the display folder part which get when create dat amodel in power bi desktop.

Rtaher than have to do that each time user uses that dataflow, woudl rather have just liked to set in the dataflow itself.  screenshot below of what do in ower bi desktop for this.