Multiple date hierarchies on the same visual

[kitti]

Hi experts,

I want to have a bar visual that shows multiple date hierarchies on X axis. For instance, on the left, it shows aggregated data by 2019/Q4 and then by month Jan, Feb, and Mar,  after that it shows week1, week2, week3 of April and then shows by day up until latest day.

How do I model data to be able to visual like that?  Is it possible in Power BI?

Thanks

KL

[sanimesa]

@kitti  Have you explored Matrix with data bars? It may not be exactly what you are looking for, but probably comes close. 

[parry2k]

@kitti yes it can be achieved but not going to be straight forward, it is going through a table and DAX. A fun thing to do though. Send me sample data and lets if I can spend time to do it.