Add A Custom Filter

Hi waseemsiddique,

According to your description, I’m not very sure about what your data model is in the Data View, and what you want to obtain using custom filter. Could you please give more detailed information about "custom filter" and desired output so that I can offer more effective solutions?

If there is ‘month’ or ‘date’ field in your data model, in this case, you could directly add the ‘month’ field to table visual so that you can see total sales per month per year. Besides, to filter table visual based on year/month selection, please add the ‘month’ field to slicer.

Best regards,
Yuliana Gu