Forum Discussion
Line chart with Legends.Show Data Label only for Current Month
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
2 Replies
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]))RETURNIF([Os in Crs] = GetMaxValue,"Black",IF([Os in Crs] = GetMinValue,"Red","white"))
If you got your solution please click on like button.RegardsBalakrishnaSr. Power-BI DeveloperThanks balakishan, I have the line. But what I want is a data label (like the tool tip that shows the data ) for current month
