Matrix glide path

[Danielwood]

Hi,

I think what I am going to ask is essentially two things in one, and therefore not possible!

I have a data set, and have set up a matrix table view. The last column is delivery dates. The collapsed table shows the latest delivery date if the items collapsed underneath. This all works fine.

What I would like to do is have a calendar view plotting those dates, so when I expand the matrix it plots those dates underneath as well as the latest date. 

Is this possible?

A simple version of the table would be:

High Level.   Sub level.   Delivery date

Fruit.              Apple.         01/06/24

Fruit.              Banana.       27/07/24

Fruit.               Kiwi.            31/11/24

So the collapsed view would be Fruit, and date plotted would be 31/11/24

Expanded view would show the above, plus 3 more rows for the sub level items, and plot their individual dates. 

Hopefully that makes sense. If a matrix table isn't the right thing please say, am happy to try out others. If it isn't possible I can work out something else.

Thanks 

[Anonymous]

Hi @Danielwood ,

You can create a matrix visual and set the same settings as the one in below screenshot:

Best Regards

[Danielwood]

Thank you for this. It does help the layout of the matrix table in that it looks far neater.

Regarding the calendar plotting aspect of the question, is this possible? 

[Anonymous]

Hi @Danielwood ,

Please check if the following visuals can help you get the expected result...

Gantt chart:

How to Build a Calendar & Gantt Chart in Power BI - YouTube

Timeline:

Timeline visuals in Power BI - YouTube

Inforiver:

inforiver.com

Best Regards