Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!
Hello everyone,
here is a Power BI beginner.
I'm looking for a way to hide the current month through a filter in a visual.
The key figure fluctuates a lot and so I only want to show valid data from the last few months.
How is that possible?
Thanks in advance.
Best regards
Alex
Solved! Go to Solution.
@Anonymous , you can create a measure like
calculate([measure], filter(Table, Table[Date] <= eomonth(Today(), -1)) )
The Power BI Data Visualization World Championships is back! It's time to submit your entry.
Check out the January 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 56 | |
| 40 | |
| 38 | |
| 21 | |
| 21 |
| User | Count |
|---|---|
| 141 | |
| 105 | |
| 63 | |
| 36 | |
| 35 |