How do I make a chart for x-axis be dynamic or match relative date filter?

[Anonymous]

I have a simple line chart that needs to change to the current month each month. Currently I deal with this by on the start of each month I  change the data range to the current start and end date of the current month. Is there a way to get PowerBI to do this automatically based on the current month? See screen shot below

[v-frfei-msft · Accepted solution]

Hi @Anonymous ,

We can create a measure as below and make the visual filtered by it.

Measure 2 = var ym = FORMAT(TODAY(),"yyyymmm")
var ymi = FORMAT(MAX('date'[Date]),"yyyymmm")
return
IF(ym=ymi,1,BLANK())

[Anonymous]

Tahnks so much. Can you give me more background on what a Measure is and how it's used conceptually?

[amitchandak]

You are already using relative date level filter in filter panel, is that not working for you?