cancel
Showing results 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

## 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])
return
CALCULATE([LTAF L12M],FILTER(Filterdate, Filterdate[Date]=_max))

LTA min LABEL =
VAR _min = MAXX(ALLSELECTED(D_Date), D_Date[11MBef])
return
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!

2 REPLIES 2
Super User

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])
return
CALCULATE(if(max('Calendar'[Date]) <_min || max('Calendar'[Date]) >_max , BLANK(), _1))

Helper II

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])
return
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?