Problem with slicering evolution %

[Drema]

Hello all!

Asking kindly about your little help in such issue.

I created matrix, with Switch and Quick measure of difference of Switch YOY (EVO %).

But when i slicering years - i am loosing this EVO%.

Please help to modify my measure. Thanks in advance

EVO % = IF( ISFILTERED('Time and dates'[Date]); ERROR("Time intelligence quick measures can only be grouped or filtered by the Power BI-provided date hierarchy or primary date column."); VAR __PREV_YEAR = CALCULATE([Measure];DATEADD('Time and dates'[Date].[Date]; -1; YEAR)) RETURN DIVIDE([Measure] - __PREV_YEAR; __PREV_YEAR))

[v-ljerr-msft]

Hi @Drema,

Could you be more precisely with the issue by post your table structures(including the relationships) with some sample/mock data, and the expected result? So that we can better assist on this issue. It's even better to just share a sample pbix file which can reproduce the issue. You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading. 

Regards

[Drema · Accepted solution]

Thanks a lot for your comment, but i already found the solution!

I chose inappropriate column for slicering years firstly (not the column with dates, but with years as numbers).

I changed a slicer and everything works correctly!

Thanks