Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello
I want to enable users to chose their own date filters on a page but I also want to always exclude today's date data from a particular visual on the page.
Is it possible to specify a relative date filter on the visual so that it will display all data apart from today's and then enable users apply page filters on top to further filter the data on the visual and the page according to their own date range?
Thanks!
Solved! Go to Solution.
Hi @UsePowerBI ,
I created the data:
Here are the steps you can follow:
1. Create measure.
flag =
IF(MAX('Table'[date])=TODAY(),0,1)
2. Place [flag] in Filter, set is=1, apply filter.
3. Use [date] as a slicer
4. Even if the slicer selects the date, only all data except today will be displayed in the visual object
5. Result:
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 @UsePowerBI ,
I created the data:
Here are the steps you can follow:
1. Create measure.
flag =
IF(MAX('Table'[date])=TODAY(),0,1)
2. Place [flag] in Filter, set is=1, apply filter.
3. Use [date] as a slicer
4. Even if the slicer selects the date, only all data except today will be displayed in the visual object
5. Result:
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.
@UsePowerBI , You can use a visual level filter to exclude the data of today. But it will be limited by the range of page-level filter if any
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
99 | |
76 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |