Data Filtering issue with Month Slicer

[Anonymous]

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

https://www.dropbox.com/s/xcuyv21vuz9vg51/test_.pbix?dl=0 

[Jihwan_Kim]

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.

[Anonymous]

Hi Kim - Not working giving me a constant value..

[amitchandak]

@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]

Can you kindly post the full measure here and i should be able to do the rest.

Thanks

[amitchandak · Accepted solution]

@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

[Anonymous]

thank you amit