Forum Discussion
Need Help Making a Date Slicer Ignore Flagged Rows
- Anonymous1 year ago
Hi MLUM
Please try this:
For better testing, I did some change to the data which you provided, here's the sample data:
Table:Then add a calculated table:
Table 2 = FILTER( VALUES('Table'[Date]), 'Table'[Date] <> BLANK() )Next, create a measure:
_Flag = VAR _Slicer = VALUES ( 'Table 2'[Date] ) RETURN IF ( ISBLANK ( SELECTEDVALUE ( 'Table'[Date] ) ), 1, IF ( SELECTEDVALUE ( 'Table'[Date] ) IN _Slicer, 0 ) )Finally, create a slicer with the field Table 2[Date] and replace the Table[Flag] with the measure[_Flag] in the table visual, the result is as follow:
Best Regards
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
So the only issue with using a date table, is the filter im using is a modified date which is a date for all dates other than the current date. For current date it shows "Today", so it is a text field rather than an actual date field.
Thanks!
I would like to help but I'm a little unclear about your requirements.
Can you provide the following?
1) Please provide sample data that covers your issue or question completely.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
2) Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
3) Please explain how you would expect to get from step 1 to 2.
4) If possible, please show your past attempts at a solution.
A .pbix file with sample data would be best.