Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Data Days is here! Join us now for 60+ days of learning, challenges, and connection. Learn more

Reply
Syndicate_Admin
Administrator
Administrator

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.

gcarrasco_0-1751651619789.png

gcarrasco_1-1751651653210.png

My need is to add a measure that is only useful for the month of April. How can I insert it?

Thank you,

Greetings.

1 ACCEPTED SOLUTION
speedramps
Super User
Super User

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()
)

 

View solution in original post

4 REPLIES 4
danextian
Super User
Super User

Hi @Syndicate_Admin 

 

Try this:

CALCULATE ( [your measure], KEEPFILTERS ( 'table'[mes] = "abril" ) )




Dane Belarmino | Microsoft MVP | Proud to be a Super User!

Did I answer your question? Mark my post as a solution!


"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.
speedramps
Super User
Super User

@Syndicate_Admin 

Thanks you for the message.

Please click the [accept solution]  button 

speedramps
Super User
Super User

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()
)

 

Thanks a lot!. It worked for me to the touch!.

Helpful resources

Announcements
Fabric Data Days is here Carousel

Fabric Data Days 2026

Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.

May Power BI Update Carousel

Power BI Monthly Update - May 2026

Check out the May 2026 Power BI update to learn about new features.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.