Forum Discussion
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
- amitchandak
Super User
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- AnonymousNot applicable
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