cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
OlegV
Helper I
Helper I

Line chart with multiples: show data label of the last date

Hello,

I am not able to show data label of the last date. I face two problems:
1) the measure does not work as I expect. Both in a table and in a Line chart

OlegV_0-1632852802672.png

table:

OlegV_1-1632853265336.png

Line chart with multiples (here it is supposed to show only markers and data labels of the last dates):

OlegV_2-1632853424620.png

 

2) I am not able to add a measure to a "Sacondary values" field after I added values to a " Values" field.

 

3 REPLIES 3
Eyelyn9
Community Support
Community Support

Hi @OlegV ,

 

1. I tried the measure you used on my side, and it worked:

avg = AVERAGE('Table'[Value])
last day avg = 
var _max=MAXX(ALL('Table'),[Date])
return CALCULATE([avg],FILTER('Table',[Date]=_max))

Eyelyn9_2-1633054984694.png

 

 2. [Value] to Values field, [avg] measure to Secondary values:

Eyelyn9_1-1633054903324.png

 

Please provide me with more details about your table and your expect outputs or share me with your pbix file after removing sensitive data.

 

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

Hello, @Eyelyn9 
Thank you for a reply. Yes, I can see that in your example a maesure works.

Please find a link to download a .pbix file with the data and my charts.

https://1drv.ms/u/s!AjD38l7_q5wZgasw9yQRp6Su73cdLQ?e=PhQh1d

or this link, if onedrive does not work

https://dropmefiles.com/E2efF

The result I would like to get is

OlegV_0-1633341973896.png

 

parry2k
Super User
Super User

@OlegV Read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors