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! ❤️
Super UserI suggest you focus on the Agent Transaction table and the Transaction Time column. Since I don't have access to your data source I cannot determine what Power Query thinks of your data. But I can tell you this: When you look at the data in the Data View and expand a column, it will show the the list of DISTINCT values. For example, if you expand Day under Dim Date you get 7 DISTINCT days of the week.
But look at the below screen shot. I have expanded the Transaction Date column and see SEVERAL rows all indicating "1/1/2023", not ONE DISTINCT row as I expected. And if I select one of the values, I get ONE row filtered. This tells me that maybe that column is actually a Date/Time column masquerading as a Date. I don't care that the Column Tools menu option in Power BI says that it is a Date. Check your Data Types in Power Query. Also, the fact that the column NAME is "Transaciton TIME" is suspecious!