Forum Discussion
Filters
The reason for this problem is that slicer is using ITEM from the fact table, you need to create another table containing ITEM and use it for slicer.
I mean, when you select W from the table below, then it will filter the table where ITEM=W and then return the max date where ITEM=W.
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
The reason for this problem is that slicer is using ITEM from the fact table, you need to create another table containing ITEM and use it for slicer.
I mean, when you select W from the table below, then it will filter the table where ITEM=W and then return the max date where ITEM=W.
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.