Timeline in PowerBI with category and sub-category

[vasher]

I want to create a simple timeline that has a category and sub-category field on the y-axis (as swimlanes), a date feild on the x-axis and events represented by bubbles along the timeline. It's easy to create in Tableau using the available gantt chart visual (image attached). However, I'm unable to create it in PowerBI using the pre-installed visualisations. I tried using the custom visual called as timeline but that didn't help either as it's very limited in scope and I can't seem to change things like adding a sub-category or representing events as bubbles instead of bars. Is it possible to create a chart similar to the attached image in PowerBI? Thanks!

[powerhelpneeded]

@lkalawski would it be possible to send the file again? Or perhaps teach me how you've set up the Matrix visual to display the timeline in that manner? Thanks!

[amitchandak]

@vasher , I doubt any visual like this. Can you check a custom visual on the app source? Matrix with conditional formatting can be a option.

https://appsource.microsoft.com/en-us/marketplace/apps?product=power-bi-visuals

[vasher]

@amitchandak  I tried the custom visuals from appsource..the only one that came close to what I needed was "as timeline" but, as mentioned in my post, it has a few limitations due to which I'm unable to achieve the intended results.

[lkalawski]

Hi @vasher 

You can try to use matrix visual to do this and instead of value you can use conditional formatting with some icons (circle points) but timeline with Year you will have on the TOP. 

Please send me sample data and I can prepare for you some example.

_______________
If I helped, please accept the solution and give kudos! 😀

[vasher]

@lkalawski Thanks for looking into this. I've included some sample data below.

Start Date	Category	Sub-category	Event	Source / DocId	Additional comments
09/10/2018	Category A	SubCategory A	This is the first event that happened on 9-Oct-18	www.google.com	Memo published
12/10/2018	Category A	SubCategory A	The government publishes a technical notice	www.bbc.com	Memo updated
17/10/2019	Category A	SubCategory B	The Council meets to discuss the issue		Memo not updated
29/10/2018	Category A	SubCategory B	D Day		Memo updated
13/11/2018	Category A	SubCategory B	Debate held
14/11/2018	Category A	SubCategory C	The Agreement was withdrawn
15/11/2018	Category B	SubCategory D	Something interesting happened this day and a meeting was held	www.apple.com
25/11/2018	Category B	SubCategory D	One of the unimportant events in 2018
26/11/2018	Category B	SubCategory D	The NGO decided to go global		Memo updated

[lkalawski]

Hi @vasher

I can do something like this:

And also we can adjust your requirements (colors, font, sizes, icon, etc.).

_______________
If I helped, please accept the solution and give kudos! 😀

[vasher]

Hi @lkalawski this looks like a potential solution! Is it possible to assign the colors based on the "category" field and make it look close to the screenshot I posted?  

[lkalawski · Accepted solution]

@vasher 

Sth like this.

_______________
If I helped, please accept the solution and give kudos! 😀

[vasher]

@lkalawski this looks great! Can you provide the pbix file to me please?

[lkalawski]

Sure, please find the link:
https://file.io/XsNfD0qawdBn

This is just a draft and quick work. You have to adapt it to your requirements and additionally you can create a measure that will return a color code value depending on the category.
If you have any questions, please write. 

_______________
If I helped, please accept the solution and give kudos! 😀 

[vasher]

Hi @lkalawski Thanks for the link and sorry for the late reply. I tried the link you posted but I get a 404 error. Is a copy-paste error or could it be that the link has expired?

[lkalawski]

Hi @vasher,
Unfortunately, the link has expired. I will try to prepared for you the new file but it will be probably tomorrow.