Forum Discussion
Date Table Slicer Not Working
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! ❤️
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! ❤️
Thank you,
TransactionTime originally did contain date and time element as well. I changed it's format to date only but still the slicer didn't work. I have created a calculated column which will have the value of the date part only from my TransactionTime column and it is working.
I wonder why changing the format of TransactionTime format to Date did not solve the issue!