Forum Discussion
Filter not working
I'm not sure why this simple task is not working as expected.
I have data of a ticketing department inventory, which includes the Create Date, and Ticket Status. I want to display the date of the oldest ticket in "new" status. Despite setting this filter for "new" only, the card is displaying the oldest ticket regardless of status, as if it is ignoring the filter. For example, I know the oldest ticket in new status is 12/03/2022 (can confirm by looking at and filtering the raw data), however Power BI is showing 01/01/2022 which is the oldest ticket, but is not a ticket in new status as per the filter.
Hovering over the card visual, IT SHOWS THE FILTER, yet the filter is not applied to the date it shows.
Card visual with a date value, filtered for "New"
As per the data view, I have filtered to show New status only, and sorted this Create Date 2 field ascending, which shows the result I am expecting to appear on the card visual.
Why does this card ignore the filter that is applied to it?
2 Replies
Hi Anonymous ,
Do you use any formula in your table? Like Calculate Column or Measure?
If you did, the formula may ignore the filter or it may not work in the order you expect.
Hope these help you.
Best Regards,
Community Support Team _Yinliw
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, thanks for your reply.
Yes, the "Create Date 2" I am using is created with a formula (the date used depends on some criteria within the data).
The Ticket Status field which is being filtered for "New" is untouched, same as it came from the database. So why does it return a row where Ticket Status != "New" ? Does Create Date 2 having a formula break the entire Filter feature?
