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

     

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Tried both proposed solutions but neither worked.

 

The events table that I have is an excel spreadsheet with 2 main columns: Event Date and Event.

 

I want to be able to hover over or click on a given month/year in the graph and have some annotation in the tooltips.

 

Here's the date table I have:

 

And here's the events table:

 

 

If I were to select/hover over the spike in the orange line right before 2018 (which would be Dec 2017), I want the tooltips to display "Dim Screen"

  • v-frfei-msft's avatar
    v-frfei-msft
    Community Support
    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)]))