Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Show items with no data doesn't work for dates

Hello! 🙂

 

I have a problem with one of my visuals. I have a date coloumn from a DimDate table. I have then created a filter which will only show me the dates within this current month. I have put this into a matrix together some some jobnumbers.

for the dates, I have then chosen "show items with no data", but when i drill down into the data, is will only show me rows with data (see picture below).

 

Please help me 😞

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi amitchandak 

     

    I solved it 😄

    It was due to the relationship between the DimDate table and the Table withthe registred work hours. It was a *:1 relation (work hours:Dimdate) with the cross filter direction going two ways. This should only be a one way.

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    6 years ago

    If possible please share a sample pbix file after removing sensitive information.
    Thanks

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi amitchandak 

       

      I solved it 😄

      It was due to the relationship between the DimDate table and the Table withthe registred work hours. It was a *:1 relation (work hours:Dimdate) with the cross filter direction going two ways. This should only be a one way.