Using a date range selected from a slicer based on one date column to filter another date column?

Anonymous ,

Thanks again for your swift response, I have responded to your questions inline below

1. Do you want the output to be filtered based on year and month?

   • Yes, that is correct. I want the output to be filtered on both month and year, ideally like the slicer in the pbix file I linked.

2. And if the field is createdate?

   • For all visuals except the 'Delivered Requests' card, the filter should be the 'createdate' field. However, for the 'Delivered Requests' card, the filter should be the 'resolutiondate' as we want to capture all tickets that were resolved within a given timeframe and not created.

3. Because it also filters other visual objects on the same page?

   • Yes, the slicer should filter all visuals on the page.

4. I think you need to create a new table and put the year and month fields of the new table in the filter to filter the results you want for both cards.

   • I have tried this, but I am getting an error when I try to create a monthcreated column to capture the month like you have in your sample file. Is there a better way to capture the month?

5. If the year and month are filtered, does it give different results than what you mentioned in your post? Does it change based on the month?

   • Apologies, but I am not too sure what you are asking. The data should change based on the month, but in the sample file you kindly generated, there is no month filter, and I am unable to capture a single month as I am encountering the following error. "A table of multiple values was supplied where a single value was expected"

Thank you for your continued support.

Regards,

Steven