Multiple date hierarchies in the same visual

[kitti]

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

[kitti]

Hi,

Not yet sir, sorry for late update. I want something like this

Would you please help?

Thanks,

KL

[kitti]

Hi 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

[v-lionel-msft · Accepted solution]

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 Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@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

https://community.powerbi.com/t5/Webinars-and-Video-Gallery/PowerBI-Time-Intelligence-Calendar-WTD-Y...

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/