Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper II
Helper II

Show starting and ending data label for line charts

Hi everyone 


I have line graphs on my Dahboard where only start and end data labels are shown using two measures:

LTA max LABEL = var _max =maxx(ALLSELECTED(D_Date),D_Date[Date])
CALCULATE([LTAF L12M],FILTER(Filterdate, Filterdate[Date]=_max))
VAR _min = MAXX(ALLSELECTED(D_Date), D_Date[11MBef])
CALCULATE([LTAF L12M],FILTER(Filterdate,  Filterdate[Date]=_min ))


I have a helping calendar so I can show rolling 12 values based on the filter context of the main calendar:

D_date is the main calendar, FilterCalendar is used for visuals.


The problem I have is if the graph does not show all the 12 month because no data is present then the data labels do not appear.




How can I make these measures dynamical so they always point at the two available data point at the start and end?

For example on the graph you can see that 3/22 has a data label but the 9/22 does not because in the filter context 2/2023 was chosen as a month. So if the graph showed 2/23 the data label for that data point would be available. 

Thank you!

Super User
Super User

@Mateja ,

Reason one -> You are using a continuous axis, it skips periods to adjust. Use a categorical axis if needed 




if need use a measure like this with the categorical axis

0 between range
Measure = var _1= SUM(Opportunity[Opportunity count]) +0
var _min = minx(ALLSELECTED('Calendar'), 'Calendar'[Date])
var _max = maxx(ALLSELECTED('Calendar'), 'Calendar'[Date])
CALCULATE(if(max('Calendar'[Date]) <_min || max('Calendar'[Date]) >_max , BLANK(), _1))

Hi @amitchandak


Thank you for your fast answer!

Unfortunately, I cannot use the categorical axis because  every month label needs to visible. Also the graphs are quite small so the M/YY works great for the visualisation.

I incorporated your solution and it works.

LTA label2 =
var _1= ([LTAF L12M2]) +0
var _min = minx(ALLSELECTED(D_Date), D_Date[Date])
var _max = maxx(ALLSELECTED(D_Date), D_Date[Date])
CALCULATE(if(max(FilterDate[Date]) <_min || max(FilterDate[Date]) >_max , BLANK(), _1))

It shows the value for the month in the filter context even if there are no values 


The problem is it only shows data label for the max value or the month that is in the filter context as seen on the picture. So it does not show the minimum value represented on the graph
Can you maybe help with this?

Note, I use a helping calendar to show rolling 12 values  when there is only one month selected in the filter context. 

So to be clear is it possible to develop a measure that would always put data labels at the start and end values so on the graph above for 2/22 and 9/22?

Helpful resources

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.