Linked Date Slicer causing all graphs to go blank

[reh169]

I have about 5 tabs that are using current year and prior year calculcations. All but one are using the job start date and that is linked to the calendar table with a one to many relationship and the slicers on the page are the year and month columns from the calendar table. I have one tab that is using the invoice created date that is also linked to the date field in the calendar table. The slicers on that tab are also the month and year columns from the calendar table, but with this one, when ever I select a year or a month all of my graphs and tables go blank as in there is no data that matches that selection, because when no month or year is selected all the data is there as it should be. I am at a loss as for the reason this should be happening. The dates are all in the same format and all are many to one relationships. The name of date type should not be causing this to happen so what else could be and how do I fix it??

[Anonymous]

Hi @reh169 ,

You might to inactive one of the relationships and find which one casue the result. Better to share your pbix to us for further analysis if you don't have any Confidential Information.

Best Regards,

Jay

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[reh169]

https://drive.google.com/open?id=1ThqruefKUYuZ119pimw716b56VQ78Lw7 

Ok so the tabs that are working are the Jobs Est & Actls, Sales Person Targets, and Actual Crane Hours and Revenue.

The tab that is not working and whenever I select the date slicers all the data goes blank if the Days to Invoice All_Created.