Forum Discussion

AJP's avatar
AJP
Advocate I
8 years ago
Solved

Annotation using a FactEvent Table? Is this Possible?

Hi All,   I am looking to annotate a line graph - I have been able to do this using the EVENT & NOTE Dax as detailed in a number of posts, however this doesn't quite give me the functionality that ...
  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    Hi Annie,

     

    If you have an Event table, you can establish relationship with the DimDate. Then add it to the Tooltip. Please check out the demo here.

    The measures could be:

    Note =
SWITCH (
    MIN ( 'DimDate'[Date] ),
    MIN ( 'DimDate'[Date] ), MIN ( 'Event'[Event] ),
    BLANK ()
)
    Event =
IF ( LEN ( [Note] ) > 0, SUM ( FactEvent[Value] ), BLANK () )

    nnotation_using_a_Fact_Event_Table

     

    Best Regards,

    Dale

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

Hi Annie,

 

If you have an Event table, you can establish relationship with the DimDate. Then add it to the Tooltip. Please check out the demo here.

The measures could be:

Note =
SWITCH (
    MIN ( 'DimDate'[Date] ),
    MIN ( 'DimDate'[Date] ), MIN ( 'Event'[Event] ),
    BLANK ()
)
Event =
IF ( LEN ( [Note] ) > 0, SUM ( FactEvent[Value] ), BLANK () )

nnotation_using_a_Fact_Event_Table

 

Best Regards,

Dale

StuBee's avatar
StuBee
Helper I
3 years ago

Hello,

 

Would you be able to upload the sample file again please.

 

This is a really useful topic, but sadly the file has been removed.

 

Thanks