Can we limit number of data labels in line chart?

[freakinaditya]

Hi all,

Is there any way that we can customize data labels of the line chart in power bi desktop?

Suppose I want only four data labels for maximum, minimum, opening and closing values to be shown in the line chart as follows-

I don't want all the data labels to be shown. Is it possible?

Thanks in advance!

[freakinaditya · Accepted solution]

I have got a custom visual, named Multi Axis Chart by xViz, which can show data labels for maximum, minimum, open and closing values. Check out here .

[Greg_Deckler]

@freakinaditya Create a measure that only returns values at the open, closed, min and max. Add this measure as a second value to your line chart. Turn on data labels and then scroll down and turn on Customize series. Turn data labels for your first value off and then your data labels from only your second measure will be displayed.

[Anonymous]

Hi Greg, Could you help with the said measure as suggested by you here?

[freakinaditya]

@Greg_Deckler I tried what you explained but I am getting three different lines on the chart. I have calculated measures for maximum and minimum values. I don't want to display three-line rather I would display a single line and maximum and minimum values to be displayed in data labels only.

What I wanted was something like this--

 Here DL stands for Data labels.

I don't want all data labels to be displayed.

[Greg_Deckler]

@freakinaditya Can you provide some sample data as text so that I can mock this up?

[freakinaditya]

@Greg_Deckler  This is a sample table having a month and a sales column.

Now I have to only show data labels for maximum and minimum values rather than displaying data labels for all values.

Month	Sale Amount
Jan	41544
Feb	4469
Mar	59496
Apr	5466
May	5986
June	98612
July	96461
Aug	44466
Sept	47974
Oct	49648
Nov	3658
Dec	49757

[v-deddai1-msft]

Hi @freakinaditya ,

I suggest you use Max and Min line in Analytics:

Open the data label option:

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai