Date range not available - Date Slicer

[jdaily83]

I am working on a large report that will be launched company wide. They have requested a between date slicer. I applied this slicer to the report and it works fine as long as nothing is filtered on the page. However, once drilled through from the landing page, the slicer just disappears completely and leaves a blank space. I tried to use a page filter instead of drilling through and the slicer gives this error message "data range not available". I'm not sure where the issue is stemming from. Data type does = Da

[Shishir22]

HI @jdaily83 ,

Can you please try using date dimension having all the dates from max date to min date of data.

It might be possible that you are not having that date in data and hence giving error.

Just give relationship to date dimension and try pulling slicer from date dimenson insted taking it from table directly.

If it fulfils your requirement, please mark it as solution.

Thanks!

[jdaily83]

Unfortunately we don't have just one main calendar table hooked up to all of the other tables. there are too many different dates on all of the tables, ie invoice date, due date, etc. it's just weird that it shows when everything is selected but not when filtered down. 

[Shishir22]

@jdaily83 - It might be possible some filter is getting passed as a drillthrough parameter which is resulting the issue.

Can you please check all the drill through parameters passed on the landing page. Extra drill through parameters should be in etalic font. Can you please go ahead and try removing it one by one?

Thanks! 

[jdaily83]

It remains blank until I remove the project name/number filter which then has the table show all of the data. there are no drill through date fields being passed through. 

[Shishir22]

So its because of project name/no field/table. You need to check the data data for that specific peoject name. Also check relationship of table from where this field is coming.

Without PBIX its very difficult to understand complete scenario. Maybe you can share after hiding sensitive data.

Thanks! 

[KayceVC]

How is your Date table associated with the table it is filtering? What is the relationship?

[jdaily83]

The date field I'm using is actually part of the accounts payable table that is displaying the date in the table itself.