Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Automatic Hierarchy with YEAR, MONTH, DAY, HOUR

Hi all, 

I would like to add to an existing automatic hierarchy the HOUR level. 

My data are in the format DD/MM/YY HH:MM:SS, and power BI automatically creates the hierarchy with YEAR, QUARTER, MONTH, DAY... i would need also the HOUR to analyze data by the hour.

 

Since in the model I have multiple coulumn with Datas (around 50 different timestamps) i'm looking for something automatic as a flag or something else to do that for all datas.

 

It seems stupid that power BI already have the hour info and cannot add a hierarchy level automatically, or at least, i didnt find that.

 

Thanks all!

2 Replies