cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted

Date filtering Error

Hi, 

 

I am wanting to use this date filter in my reports: 

 

Date filter.PNG

 

I am also wanting to do a Year over Year comparison with the data after the date is selected:

 

yoy help.PNG    yoy help2.PNG

 

As you can see, I filtered the October 17, 2016 - October 17, 2017; it's given me just that [ NOT year over year ].

 

 If I filter just October 17, 2017; 2016 column goes away Smiley Sad

 

yoy help2.PNG

 

 

 

Could someone please help in this?

 

8 REPLIES 8
Super User
Super User

Re: Date filtering Error

Hi,

 

Your question is not clear.  What do you want to show in the Table visual?

Re: Date filtering Error

Hi,

I want to show current and last year's count for the same month and day that's filtered by the date slicer.
Super User
Super User

Re: Date filtering Error

Hi,

 

Try to use the SAMEPERIODLASTYEAR() function.

Re: Date filtering Error

How would I factor it into my sum measures?

The table is counting total Sales. I am unsure how to use it within this visual.
Super User
Super User

Re: Date filtering Error

Hi,

 

Share the link from where i can download your file.

Re: Date filtering Error

I attempted the "sameperiodlast year" function.. and got this error when using it in the matrix:

 

:: Function 'SAMEPERIODLASTYEAR' expects a contiguous selection when the date column comes from a table on the 1-side of bi-derectional relationship

 

Super User
Super User

Re: Date filtering Error

Hi,

 

Share the link from where i can download your file.  Please also show there the result you are expecting.

Community Support Team
Community Support Team

Re: Date filtering Error

HI @ThePowerBIQueen,

 

>> If I filter just October 17, 2017; 2016 column goes away Smiley Sad

Current slicer only support show the filtered part. If you removed the 2016 part in your slicer, matrix visual will shows the filtered 2017 part.

In my opinion, I'd like to suggest you write a measure to get the previous records based on calendar date.

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |