Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
1 year ago
Solved

Position a measure on a date on a chart?

Good afternoon, Thank you very much for the help you give me here! I have a graph that you place data manually, and in the power bi you graph it. My need is to add a measure that...
  • speedramps's avatar
    1 year ago

    Try something like this

     

    Use the SELECTEDVALUE to get the cursor month name

     

    If the month is april then return your measure value,

    otherwise return a blank

    Please click thumbs up because I have tried to help.

    Then click accept solution if it works.  Thank you,

     

    Answer =
    var cursor_month = SELECTEDVALUE(yourtable[monthname])
    
    RETURN
    IF(cursor_month = "April", 
    [yourmeasure],
    BLANK()
    )