Bug or Pilot error?. When slicer with between date ranges work, but use list causes disappearance.

[mikelee1701]

Hi

This has really been a pain and I can't figure it out.

When using a filter slicer with between date ranges everything is fine, but use list filters causes my graph to disappear.

Background:

I am using the following dax for two date ranges from a table to compare:

PrevValue =

CALCULATE(

sum('SP_chart'[Value]),

ALL('Date'[Date]),

USERELATIONSHIP('Date'[Date],'PrevDate'[Date]))

my model looks liket this:

 

If I use the slicer date range, my graphs work fine.

it shows the previous period vs current period just like it should:

However, if I use the List slider, my previous period graph totally disappears:

 

I am using the same dates from the 'previous Date' table, and I am using the same 'date' from the date table, just basically switching from the "between" slicer to the "list" slicer.

I put a two test date table (in the middle) and the dates are definately filtered in correctly.

Can anyone help figure out this phenonomon? 

Thanks,

Mike

[amitchandak · Accepted solution]

@mikelee1701 , for two date range, refer if my blog can help

https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601

Or if you just want them separate , you can use interactions

https://www.youtube.com/watch?v=GIfRKzhMaR4

[mikelee1701]

Using your Dax code this comparison method works much better!

THANK YOU@