How to draw time series trajectory with Power BI

[Anonymous]

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.

[v-xiaotang]

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.

[Anonymous · Accepted solution]

@v-xiaotang 

Thank you for your comment; my colleague kindly helped me to do so with Python.