Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello. I have a matrix that combines data from two datasets. Each dataset has a date, which I'm using to filter my data. The problem is that both date filters affect both datasets, which results in incorrect data. Is it possible to only apply a filter to a specific column?
In this example, I'd like the Time Entry Date Entered slicer to filter the Hours columns, and the Service Ticket Date Entered slicer to filter the Tickets columns.
FYI, Service Tickets are a parent record to the child Time Entry records. I tried changing the cross filter direction to Single, but that broke the matrix.
Thank you for reading.
Solved! Go to Solution.
Filter direction should be single. Use a different visual or break the matrix visual into two separate ones.
Filter direction should be single. Use a different visual or break the matrix visual into two separate ones.
User | Count |
---|---|
101 | |
91 | |
83 | |
76 | |
71 |
User | Count |
---|---|
113 | |
104 | |
100 | |
73 | |
65 |