Data filtering

[Moeez]

So, when we're filtering all data from day, month, and year (selecting all function).
Now, 5 out of 6 visuals are filtering data but 1 isn't doing that.
Below attached is the query used for filtering and visuals screenshot is attached.

  

[Kaviraj11]

DATESMTD & DATEADD are time intelligence function. Make sure your data model supports these time intelligence functions. For example, you need a continuous date column for these functions to work correctly. So please create a date table and reference the date column from that in your query.

[Moeez]

can you please connect with us on google meet link? so we can better understand 

[Kaviraj11]

does your data model consist of date table? If not, Ensure that your ActualDate table is linked to your date table in the data model. 

MTD Sales = CALCULATE([Sales], DATESMTD(DATEADD(ActualDate[Date], -1, DAY)))

[Moeez]

OCAC master data actual date (column), is not connected to table calendar dates(Column).