Plot a line chart with data contains "=" and range of values

[Anonymous]

I have a set of ranking data that contains "=" and a range of values

Below is the test data: 

Year	ranking
2018	98=
2019	123
2020	395
2021	321=
2022	480
2023	491-500

I am trying to plot a line chart as follows, could anyone suggest how could I plot it in PowerBI or how cound I amend the data in PowerBI to plot this line chart?

The data label should display as follows:

[DOLEARY85]

Hi,

is the ranking field in the data source? if so you can use replace it in power query by using replace values in on the transform ribbon, just enter = in the find box and leave the replace blank.

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

[Anonymous]

Hi,

Thank you for your reply.

The ranking field is the data source. If using the replace function, the line chart will not show the "=" in the line chart. I would like to show the raw data in the line chart.

In addtion, some of the year using a range of value (e.g. 491-500). I am not sure how could I plot a line chart with data that contains plain integer (e.g. rank 123 in 2019) , interger with "=" (e.g. rank 321= in 2021) and a range of value (rank 491-500 in 2023).

[DOLEARY85]

I don't think you're going to have much success plotting those values due to the non numeric elements. Could you create another field that removes the additional = etc. plot those and use the current ranking value as a tool tip?

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
 

[Anonymous]

How could I only show the current ranking value as a tooltip? I find both data will show on it

[DOLEARY85]

If you create a new page and set that page to tooltip:

then put your column/measure on there 

go back to the chart on the original page and format the tool tip of the chart to pick up that page.

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

[Anonymous]

It seems great! One more question: how could I amend the size of the tooltip as it seems too large when I go back to the original page.

[DOLEARY85 · Accepted solution]

No problem, on the tool tip page, select somewhere on the canvas and in the format pane there should be a Canvas settings. The type will adjust the size, tooltip size might be a little large still for your measure. If you slect custom youu can manually adjust it.

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

[Anonymous]

Thank you for all your information!😀

[DOLEARY85]

No problem, happy to help 🙂