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 measu...
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
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