Forum Discussion
Data Filtering issue with Month Slicer
Hi Experts
I am trying to filter my data using a month slicer - however it onlu gives me the values fro Mar 21 and the slicer returns back zero values of all other periods in 2021.
Sample file
Anonymous , Try
lastest month = month(maxx(allselected('Date'), 'Date'[Date])) -1
or
lastest month = month(maxx(allselected('DimDate'), 'DimDate'[Date]))
let rest be the same as of now
6 Replies
Anonymous , In all you Measures in the table you have filtered on lastest month , which based on today().
Ideally it should be maxx(allselected('Date'), 'Date'[Date]), if you want slicer to work
Anonymous , Try
lastest month = month(maxx(allselected('Date'), 'Date'[Date])) -1
or
lastest month = month(maxx(allselected('DimDate'), 'DimDate'[Date]))
let rest be the same as of now
Hi, Anonymous
Please try to change your filter like below.
FILTER(ALLselect('Test Data_'),MONTH('Test Data_'[cr03a_period])=[Latest Month])Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster.
