topic Re: Line chart with Legends.Show Data Label only for Current Month in Custom Visuals Development Discussion

Line chart with Legends.Show Data Label only for Current Month

Brijith — Wed, 25 Jun 2025 07:43:25 GMT

I have a Line Chart in Power BI with a legend (e.g., "Actual", "Forecast", etc.).
The X-axis is 'dim_Calendar'[Year Month] (formatted as "yyyy-MMM", not a date hierarchy).
The Y-axis is a measure: Cumulative Count .
The Legend is 'Dates'[Date Category]. ("Actual", "Forecast".)

I want to: Show a vertical line at the current month (e.g., June 2025). Display data labels only at that point (i.e., for June 2025) for all legend series. The X-axis spans from May 2024 to March 2027, and I want this to work dynamically — so that next month, the vertical line and labels shift to July 2025, and so on.

The following image is in the tooltip when I point to May with the mouse. So my requirement is can we show the tooltip permanently for current month

Re: Line chart with Legends.Show Data Label only for Current Month

121Balu — Wed, 25 Jun 2025 05:59:45 GMT

Dear @Brijith

You can use below dax and apply in font colour fromat option.

MAX 23 =

VAR GetAllMarket = ALLSELECTED(Query1[MATURITY_DATE].[Day])

VAR GetMaxValue= MAXX(GetAllMarket, CALCULATE([Os in Crs]))

VAR GetMinValue= MINX(GetAllMarket, CALCULATE([Os in Crs]))

RETURN

IF([Os in Crs] = GetMaxValue,"Black",IF([Os in Crs] = GetMinValue,"Red","white")

)

If you got your solution please click on like button.

Regards

Balakrishna

Sr. Power-BI Developer

Re: Line chart with Legends.Show Data Label only for Current Month

Brijith — Wed, 25 Jun 2025 10:54:42 GMT

Thanks balakishan, I have the line. But what I want is a data label (like the tool tip that shows the data ) for current month