Is there a way to show data labels value or title for 1 point only ?

[wonka1234]

Hi,

Is there a way to display my data labels value or title only once? Other then just make a card i want to see if it can be done using data labels option.

Ie this is my line

and i want to add value and label to only 1 data point (not all 3).

I only want to show it once

thanks.

[kushanNa · Accepted solution]

Hi @wonka1234 

If you need to get only one data point, you will need to create a measure and ask it to return the value for that single data point, then display it as another line point.

please find the example attached below 

Thank you @V-yubandi-msft for your PBIX file. Since I was a bit too lazy to create a new one, I used your sample file data to modify 😄

[wonka1234]

@kushanNa  only issue is that i cant hide the 2nd line from the legend 😞 and for seom reson my line is displayed as .40 and not 40%

[kushanNa]

Oh, if you don't want to click on the legend, you can just hide it and use an image of the legend without the second line

[wonka1234]

how did you get it to display 40% instead of .40?

[kushanNa]

click on the measure and click on the percentage icon 

[wonka1234]

thanks! if i wanted to add text to it ie "KPI 40%" can that be done in the measure?

[kushanNa]

Yes, you can use Dynamic format String 

Click on the measure and select format> Dynamic 

and copy and past the following code 

"KPI #,0%"

output should look like this 

[wonka1234]

thanks. what if i need to show decimals? My % is showing 3 but the actual value should be 2.5%

[kushanNa]

change the code to following 

"KPI #,0.0%"

[V-yubandi-msft]

Hi @wonka1234 ,

Thank you for reaching out to the Fabric Community. I’ve attached a .pbix file based on your requirement. When you get a chance, please review it and let me know if any changes are needed.

The dashed line represents the 40% KPI target.

Warm regards,
Yugandhar

[HarishKM]

@wonka1234 Hey,
As per your available data. I have implemented similer ask for my report. Adding image for your reference.

to Implement above. Kindly follow below steps

1) Create your desired visual

2) Click add further analysis to your visual in format painter ribbon on right side

3) Add X or Y as per your selected visual

4) Change line color to your desired color

5) turn on data label for the same.

Thanks

Harish KM

If above step's solved your problem. Kudos will be highly apprieciated. Accept this as solution as well

[wonka1234]

@HarishKM  i am doing a line and stacked chart. So I already have the y axis line in the build visual view.

its tricky to do - if i remove the "column y axis" line and try to use the futher analysis, i am not sure which number to input. My numbers are Percantages. Ie I want the line to be at 40%.

here is my photo using "column y axis" line -