Forum Discussion
Helper IIIMultiple date hierarchies in the same visual
Hello experts,
I want to have a bar visual that displays multiple date hierarchies on the X axis. For example, on the left, it displays aggregated data for 2019/Q4 and then by January, February, and Sea month, after that it shows week1, week2, April week3, and then is displayed as a day until the last day.
How do you model the data so you can visualize it like this? Is it possible in Power BI?
Thank you
In
Hi kitti ,
Yo can create calculated columns for year, quarter, month, week, and then use these columns to create new hierarchy.
Year = [Date].[Year] Quarter = [Date].[QuarterNo] Month = [Date].[Month] Week = WEEKDAY( [Date] )Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
5 Replies
v-lionel-msftCommunity Support
Hi kitti ,
Yo can create calculated columns for year, quarter, month, week, and then use these columns to create new hierarchy.
Year = [Date].[Year] Quarter = [Date].[QuarterNo] Month = [Date].[Month] Week = WEEKDAY( [Date] )Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- amitchandak
Super User
kitti , You create the required column in you date table and create custom hierarchy
https://www.youtube.com/watch?v=WWvVeYU0Dvw
How to create various column
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions
https://www.archerpoint.com/blog/Posts/creating-date-table-power-bi
https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/ 
kittiHi All,
I will try those methods, but it's going to take some time to study. Then I will come back with the results. Thanks!!
KL
- v-lionel-msft
Hi kitti ,
Has your problem been solved? If yes, please consider Accept it as the solution to help the other members find it more quickly.
Best regards,
Lionel Chen
- kitti
Hi,
Not yet sir, sorry for late update. I want something like this
Would you please help?
Thanks,
KL
