Forum Discussion

kitti's avatar
kitti
Helper III
6 years ago

Multiple date hierarchies on the same visual

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

Interesting Links
Need Help
Tips and Tricks
Tutorial Requests

2 Replies

  • parry2k's avatar
    parry2k
    Super User
    6 years ago

    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.

     

  • sanimesa's avatar
    sanimesa
    Post Prodigy
    6 years ago

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