Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more
Hi Power BI experts,
Could someone please advise me on how to draw a time series trajectory with Power BI?
Assuming we have these dummy data/scenarios below, I would like to verify if the more visitors we have at the restaurant, the less rating the customer will leave on Google Maps.
Thank you in advance!
| Rating | Visitor | |
| 2017/1/1 | 5 | 7698 |
| 2017/1/2 | 4 | 9076 |
| 2017/1/3 | 4.166667 | 8180 |
| 2017/1/4 | 4 | 6973 |
| 2017/1/5 | 4.333333 | 2011 |
| 2017/1/6 | 3.28911 | 3904 |
| 2017/1/7 | 4.333333 | 5465 |
| 2017/1/8 | 4 | 6990 |
| 2017/1/9 | 2.1918 | 6176 |
| 2017/1/10 | 5 | 3813 |
The ideal visualization would look like this.
Solved! Go to Solution.
Thank you for your comment; my colleague kindly helped me to do so with Python.
Hi @Anonymous
Thanks for reaching out to us.
As far as I know, it is not possible to realize time series trajectory in Power BI, as a workaround, maybe you can use rank or color gradients of conditional formatting. Or you can create an idea at Ideas (powerbi.com) then others who have the same idea can vote for it.
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
Thank you for your comment; my colleague kindly helped me to do so with Python.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.