The divide measure shows the blank months/years even though my slicers are selected to one year.
If I remove the divide measure, the data works fine based on the filter.
Even I tried to filter the date field but no luck.
enter image description here
Even using the divide measure, it should work normally based on the slicer selection.
New contributor
Prabu Venkatachalam is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
1
Switch ALL to ALLSELECTED. See ALLSELECTED
Tip: DIVIDE function vs. divide operator (/)