Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Annotating graph with events

I have a graph that's plotted with a Date Table with MMM-YYYY as the x-axis (shown below):   I want to add annotations to it via the tooltips but need some help. I created another table with...
Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    6 years ago

    Hi Anonymous ,

     

    We can create a inactive relationship between tables based on _Date table [_Date(months)] and Event table[_Event Date(Month)]. Then we can use the measure as tooltips to work on.

     

    tooltip= CALCULATE (MAX(Event table[Event]),userelationship (_Date table [_Date(months)],Event table[_Event Date(Month)]))

     

     

Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago

Sure, you could do something like the following. Obviously I do not know your tables and code but hopefully this gets the idea across.

 

ToolTip Measure = 
VAR __Date = MAX('Date Table'[Date])
RETURN
  CONCANTENATEX(
    FILTER(
      'Events',
      [EventDate] = __Date
    ),
    [Description],
    ","
  )