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

     

     

amitchandak's avatar
amitchandak
Super User
6 years ago

The information you have provided is not making the problem clear to me.

But if you date table is at date level and you trying to join the data to MMM-YYYY column from another table which data in MMM-YYYY format, that will create Many to Many. Better would be

 

Create date in another table

Date = "01-" & Table[Month Year] // Only if it is in MMM-YYYY format.

Change data type of this as date. And Join using This new date to date table