Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I have a table with date and other fields. I want to filter the visual so that it shows the all the data from 04/01/2022 until yesterday.
How do I do that?
Hi @bml123 ,
If the start date and end date are fixed, please specify a range of date column in the filter pane.
If the range is dynamic, please try creating the following measure and displaying items when the value is not blank.
Measure =
COUNTROWS (
FILTER (
'Table',
'Table'[Date] >= DATE ( 2022, 1, 4 )
&& 'Table'[Date]
<= TODAY () - 1
)
)
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@bml123 , I am assuming 4th Jan 2022. Or you need from 1-april -2021
Try a measure like
calculate(sum(Table[Value]), filter(Table, Table[Date] >= date(2022,01,01) && Table[Date] <=today() ) )
If there are too many measure to convert, use this visual level filter, check for non blank
Hi @amitchandak
The table has lot of measures. I want to display the whole set of data where the date is after 04 January 2022 until yesterday.
How do I do that?
User | Count |
---|---|
128 | |
108 | |
100 | |
64 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |