Automatic Hierarchy with YEAR, MONTH, DAY, HOUR

[Anonymous]

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!

[amitchandak]

@Anonymous , I think you can try creating a custom Hierarchy

https://stoneridgesoftware.com/creating-hierarchies-in-power-bi/
https://www.youtube.com/watch?v=x6vXVJZ_eTY

[Anonymous]

Noted, and thank you.

However, creating a custom hierarchy implies that i would need to create a custom hierarchy for all datas (50 coulum).

Is there any whay to avoid this problem