Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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.
Solved! Go to 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
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
Looks good but unfortunetly PowerBi shows that: Coulm Date in table Table cannot be found or may not be used in this expression
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the February 2025 Power BI update to learn about new features.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
84 | |
69 | |
68 | |
39 | |
37 |