Date Slicers are not filtering if full range is selected

[xboxter]

I have a simple two table report where items in the first table are filtered by an associated date in the second table. The number of items in the first table is 316000, the number of linked items in the second table is 5090. If I apply a slicer with the date range from the second table it filters properly, unless I extend the slicer to the far left and far right. Where it should show me the 5090 possible items linked to the second table I instead see a full count of 316000 from the first table. It seems that extending a slicer to full range removes it as a filter completely. Is including the full range of slicer supposed to completely remove it as a filter?

Short One Day From the Left

Short One Day From the Right

Full Range:

 

[Anonymous]

Hi,

it still works this way. So annoying.

The issue is that if you have dates from 2000/01/01 to 2010/03/21 and if you apply slicer + filter on page, where filter on page filters it to let's say past 3 weeks. Slicer works fine but if you go on slicer to far left and far right so you want to see only last 3 weeks it stop working and starts showing full (2000/01/01/ - 2010/03/21) range.

Any ideas?

thanks

daniel

[Sean]

@xboxter  which COUNT function are you using (here you can see the functions)

https://msdn.microsoft.com/en-us/library/ee634956.aspx

COUNTROWS ( Table ) = COUNTA ( Table[Column] ) + COUNTBLANK ( Table[Column] )

COUNTROWS - counts all rows

COUNTA - will not count blanks

COUNTBLANK - only blanks

Try using COUNTROWS ( Table ) for your Measure it picks up everything

Hope this helps!

[xboxter]

I'm not doing this with a measure, it's just the value with count (distinct).

[Sean]

@xboxter

1) switch to Count NOT Count (distinct)

or

2) create a new MEASURE

IDs = COUNTROWS ( YourTableNameOnly )

and use it in the Card Visual instead

Does this give the correct result?

[v-qiuyu-msft]

Hi @xboxter,

Is @Sean's suggestion helpful to you? Is the issue solved now?

Best Regards,
Qiuyun Yu

[xboxter]

Sean's suggestion is a viable workaround. But the function of the software seems to be a little off. I wouldn't think the the slicer should be ignored just becuase it is at it's full range.