Forum Discussion

Frequent Visitor

4 years ago

Solved

Show only latest data labels in a Line Chart

Good afternoon, community. Straight to business: I want to display only the latest value on the end of each line of this Chart

To find the latest value I created this measure:

valor_max =

VAR max_data = CALCULATE(MAX(base_dash[data]), ALLSELECTED(base_dash[data]))

RETURN

IF( MAX(base_dash[data]) >= maxdata, [medidores_noticados])

But now I don't know how to display it as a data lable.

Tips and Tricks

Jeanxyz
4 years ago
marciomendonca ,Have you tried Charticulator? Here is how I created a chart only showing the data label of last month.

5 Replies

amitchandak
Super User
4 years ago
marciomendonca , I tried something long time back, see if that can help

https://community.powerbi.com/t5/Community-Blog/Display-Label-Only-on-the-Last-Data-Point-of-the-Line-Visual-for/ba-p/1253464
- marciomendonca
  Frequent Visitor
  4 years ago
  I really appreciate your reply, amitchandak . But, sadly, didn't work 😞
Jeanxyz
Power Participant
4 years ago
This can be done via Charticulator. You will need to create a new measure to define the earlies date in your visual and manage data lable visibility based on this measure.

Here is a video show how-to. I think you can find the information needed aroudn 1 hr 10 min

https://www.youtube.com/watch?v=1tp6ZqWjFso&t=2373s
Jeanxyz
Power Participant
4 years ago
marciomendonca ,Have you tried Charticulator? Here is how I created a chart only showing the data label of last month.
- marciomendonca
  Frequent Visitor
  4 years ago
  Thank you very much! Worked like a charm 🙂