Data missing in visualizations

[cpatriarca]

I'm having several issues with dates, tables, and visualizations.  Most recently my visualizations are not showing data past November 30, 2021.  The Dec. 2021, Jan. 2022, and Feb. 2022 data shows in the table view, but not on the vizualizations. 

Here's a snapshot of a visualization only showing data through Nov. 2021.  Yes I did check my filters, all months for 2021 and 2022 are applied.

Here's a snapshot of my data table view, clearly see data for Jan. 2022.

I use a dates table created with DAX, see below.

Dates =

VAR BaseCalendar =

CALENDAR ( DATE ( 2017, 1, 1 ), DATE ( 2022, 12, 31 ) )

RETURN

GENERATE (

BaseCalendar,

VAR BaseDate = [Date]

VAR YearDate = YEAR ( BaseDate )

VAR MonthNumber = MONTH ( BaseDate )

VAR MonthName = FORMAT ( BaseDate, "mmmm" )

VAR YearMonthName = FORMAT ( BaseDate, "mmm yy" )

VAR YearMonthNumber = YearDate * 12 + MonthNumber - 1

RETURN ROW (

"Day", BaseDate,

"Year", YearDate,

"Month Number", MonthNumber,

"Month", MonthName,

"Year Month Number", YearMonthNumber,

"Year Month", YearMonthName

)

)

I also have relationships with this table which does not connect all data between the tables in the relationships.

Please help, I can provide additional information.

Thanks,

Carmen

[Anonymous]

Hi @cpatriarca ,

Does that make sense? If so, kindly mark my answer as the solution to close the case please. Thanks in advance.

Best Regards

Community Support Team _ Polly

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

[Anonymous]

Hi @cpatriarca ,

You could check relationships in your model tab. Disable all relationships and check if report is normal.

Or please check can you see all the data in Queries.

If you can, could you please check that if you have unchecked the "Enable load":

Or if all the value are 0, please click show with no data.

Please check Whether the start date and end date on the line chart are set manually? You can fill in the start date and end date manually to make sure all dates are in the range

If the error still exists, please provide your pbix file without privacy information.

Best Regards

Community Support Team _ Polly

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

[Greg_Deckler]

@cpatriarca Check your report level filters. Also check your measures and make sure they aren't doing the filtering.

[cpatriarca]

That helped, thank you!  I cleared all filters on all pages and the data is now showing up for Dec. 2021 and Jan. 2022.

Can you help with my relationships?

[Greg_Deckler]

@cpatriarca Well, you could make that upper right relationship Both and that would have every table filtering every other table if that is what you are talking about. The Italians wouldn't like it that way, Both direction relationships are bad as far as they are concerned. And, it is true that Single direction relationships are best practice and you use CROSSFILTER function to swith things when needed within Measures. But, whatever works for you and is within your abilities. 

[Syk]

Make sure you don't have any filters applied under 'Filters on all pages' that might limit what you're able to see.

[cpatriarca]

Did that, and there are no date filters applied on all pages.

[Greg_Deckler · Accepted solution]

@cpatriarca Are there any drill through filters set? Those show up in the Visualizations pane at the bottom. Also, check your measures. Another possibility is that some slicer on some page is set and there is a hidden, synced slicer on the page so check your Selections pane.

[cpatriarca]

I should add that no vizualizations in the entire model are showing data past Nov. 30, 2021.