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! Get ahead of the game and start preparing now! Learn more
I was having trouble with the date filter. For example, if i select this date range, I want all the data that is between 01/01/2019 and 01/01/2021 but not including the values on 01/01/2021.
However, the issue with this filter is that it includes the values on 01/01/2021.
I was wondering if anyone had the same issue or if there was anything I could do to fix this
Solved! Go to Solution.
Hi,
the only solution i can find is this:
To achieve it you have to create another column in your calendar
the other on before with Before Date +1
If this post isuseful to help you to solve your issue consider giving the post a thumbs up and accepting it as a solution !
I was wondering if you knew of a way for me to still select 01/01/2021 but not include the data values for 01/01/2021. Like if there were measures I would have to make or something.
Hi,
the only solution i can find is this:
To achieve it you have to create another column in your calendar
the other on before with Before Date +1
If this post isuseful to help you to solve your issue consider giving the post a thumbs up and accepting it as a solution !
Hi,
probably you have to select 31/12/2020 and not 01/01/2021
If this post isuseful to help you to solve your issue consider giving the post a thumbs up and accepting it as a solution !
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 40 | |
| 36 | |
| 34 | |
| 31 | |
| 27 |
| User | Count |
|---|---|
| 136 | |
| 103 | |
| 66 | |
| 65 | |
| 56 |