Why the Rows filter (transaction date) does not show?

[MayaKe]

I am trying to plot Sales by Transaction Date as a matrix but Transaction Date does not show as a list of all the dates. What settings do I need to adjust?

[MayaKe]

You are correct. The relationship between the two tables was not properly established. I had selected the wrong column on the 1-side. Thank you!

[amitchandak · Accepted solution]

@MayaKe , Is it coming from same table, Hope there is not filter removing it

If from a different table, It means missing data the 1- side of the table in 1-m join

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.