Line chart - change data label to percentage

[Anonymous]

Hi All,

I've been working on PowerBI for a while and stuck in line chart label. What I am trying to do is without changing the y-axis value, I only want to display percentage in label. It should look like this:

The value that line chart represents still the real value, but label is percentage. Is there a way of doing this or a workaround other than using tooltips.

Thanks in advance !

[v-yuta-msft]

Hi neandertal,

Drag Percentage column to Values field:

 

Regards,

Jimmy Tao

[Anonymous]

Hi Jimmy @v-yuta-msft,

I want to display "percentage value" in the "tax label" without changing the tax line position.

Your solution is not what I want and it is only an extra line at the bottom.

I want the chart as this: The red line is tax value but labels are percentage value.

Is there any other options or workaround for this?

Thanks!

[v-yuta-msft · Accepted solution]

@Anonymous,

I'm afraid this may can't be achieved in power bi because the label shows y-axis value which can't be changed in line chart. You can submit your idea here.

Regards,

Jimmy Tao

[v-yuta-msft]

Hi neandertal,

Could you share some sample data and clarify more details about your requirement?

Regards,

Jimmy Tao

[Anonymous]

Hi Jimmy @v-yuta-msft,

Here is a sample pbix and the data source.

https://drive.google.com/open?id=1OCTsTAYzAF4560qSa6jFNLoeiMvLxVfB

Basically I need to plot two lines in a chart, one is for total income and the other one is tax. I created a report and you can see it in the attached file.

Here is the issue: There is a percentage field in the data source. What I want to do is to change the label for tax line and show percentage in this label without changing the y-axis and tax values. In the report the percentage is in tool tip but I need this to be displayed as label not in tool tip. (Also this percentage can be calculated on the fly, it doesn't need to be a field if it is easier to do.) 

Thanks!