how to set the current month to be shown automatically

[SD97]

Hey, I need to set the current month to be displayed automatically, so far I had to change the display of a specific month in the filter every month after loading the data. I would like powerbi to use the current month itself (data refreshed weekly), I will add that the data includes forecast.

[v-yangliu-msft · Accepted solution]

Hi  @SD97 ,

I created some data:

Here are the steps you can follow：

1. We can click "Get more visual" to add the "Preselected Slicer".

2. We need to create a table like this.

3. Then we can create a measure .

Measure =
var _slicer_date = SELECTEDVALUE('Table'[Column])
var _today=TODAY()
var _month=
MAXX(
   FILTER(ALL('Table'),'Table'[Date]=_today),[Column])
return
IF(
    _slicer_date = _month,TRUE(),FALSE() )

 4. Then we put theses fields on the visual and we can meet your need:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[SD97]

Looks good but unfortunetly PowerBi shows that: Coulm Date in table Table cannot be found or may not be used in this expression