Forum Discussion

mshaivitz's avatar
mshaivitz
Frequent Visitor
7 years ago

Annotating in a Line Chart with

Hi - I'm using this tutorial as the basis for adding an annotation. https://community.powerbi.com/t5/Webinars-and-Video-Gallery/Annotating-Specific-Events-in-Line-Charts/m-p/151665#M20   I am usin...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Community Champion
7 years ago

You should be able to do something like:

 

 

Note = 
VAR __city = MAX('Table'[City])
RETURN
SWITCH(
MAX(India[reportingdate] ), 
VALUE("10/1/2017" ), "Implementation begins in " & __city,
VALUE("04/1/2018" ), "Implementation begins in " & __city,
VALUE("05/1/2018" ), "Implementation begins in " & __city,
BLANK()
)
  • mshaivitz's avatar
    mshaivitz
    Frequent Visitor
    7 years ago

    HI Greg, thank you so much, this is working. I'm wondering if you could help me around two issues I'm having:

     

    1) When all the filters are selected, it shows a few random implementation dates - is this an IF statement, such as 'IF ALL Filters are selected, then show no dates"?

     

    2) What would I need to do to show multiple start dates if more than one filter is selected?

     

    Thank you, I appreciate your time.