Forum Discussion

MayaKe's avatar
MayaKe
Regular Visitor
4 years ago
Solved

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

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 , 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.

2 Replies

  • 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.

  • MayaKe's avatar
    MayaKe
    Regular Visitor

    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!