Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Date Table Slicer Not Working

Hello,    I have spent too much time on this and I can't seem to find the solution, I have a report with date table and some other table (agent_transactions) where it has transaction info and Trans...
Need Help
  • parry2k's avatar
    parry2k
    3 years ago

    Anonymous as others suggested, the transaction time column contains the time element with it, to test, I added a new column using DAX and called it Transaction Date and have a relationship with the Date dimension and everything is working as expected. Check the attached file.

     

     

     

    👉 Learn Power BI and Fabric - subscribe to our YT channel - @PowerBIHowTo

    If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤️

Idrissshatila's avatar
Idrissshatila
Icon for Super User rankSuper User
3 years ago

Hello Anonymous ,

 

I've spent sometime looking into your report and trying to figure out what's wrong, also I created a new dim date table using calendar auto and connected it with your transaction table and yet its giving the same issue.

 

I agree with ToddChitt , that there's something suspicious in the transaction time column but we can check the transaction table in Power query since we don't have access to the db. so I sugest to look into the transaction time column in Power query because it seems that the problem is from there.

 

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote For my Idea 💡