Dear Enterprise DNA forum,
I would like to ask your help to find a solution to this little problem. I am working with a very basic dataset about the top 10 tennis players ranking over a number of years. Just 3 columns: Year, Player, Ranking (1 to 10). Some players appear for many years, often with different ranking, some just once.
In my exercise, I am preparing a line chart visualization to show how their presence in the Top 10 evolved over the time they have been in (Year on the X and Ranking on the Y). For some players, their presence in the Top10 is not continuous, for example this one:
How can I make sure the line chart is discontinued for those years? What Power BI seems to naturally do is just interpolating between the two closest years, like here:
Thanks a lot in advance, really appreciate your support