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[enter image description here](https://i.sstatic.net/TDykjxJj.jpg) query used for filtering and visuals screenshot is attached.
almost everything like changing querys MTD Sales = CALCULATE([Sales], DATESMTD(DATEADD(ActualDate[Date], -1, DAY)))
New contributor
Moeez Bin Nadeem is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.