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

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Dale,

I have a matrix visual on my page, that I am using to filter my line chart. If I click on an item name, the line chart shows filters to the revenue for that item only. I want the chart to also filter to only show the event and note for that item as well.  How would you adjust the Note or Event measures to work for this? ic item through the matrix? 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Did you solve this problem?