Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to Solution.
Sth like this.
_______________
If I helped, please accept the solution and give kudos! 😀
@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
@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.
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! 😀
@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 |
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! 😀
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?
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! 😀
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
95 | |
80 | |
67 | |
62 |
User | Count |
---|---|
138 | |
107 | |
104 | |
82 | |
63 |