Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Linked Date Slicer causing all graphs to go blank

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??

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous ,

     

    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.