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 is only useful for the month of April. How can I insert it?

Thank you,

Greetings.

  • speedramps's avatar
    speedramps
    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()
)

     

4 Replies

  • speedramps's avatar
    speedramps
    Icon for Super User rankSuper User
    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()
)