Forum Discussion
Helper IIISlicer with dates wont filter out values before a certain date
Hi. In PBI I have a column with counterpart and another column with values. I have a slicer that shows "from" and "to" trade date. When I reduce the "to" date, some values for some counterpart should change because it should change values that was before and after a certain trade date. But the values shows the same. Its working for some trade dates and counterparts but not others. Why is that happening?
Hi LFM,
Thanks for reaching out to the Microsoft Fabric Community forum.
If your slicer is directly targeting the Trade Date, ensure that the Trade Date field has an active relationship with your fact table. Without an active relationship, the slicer will not filter the data as expected. Implementing a dedicated Date Dimension is highly recommended if not already in place.
Review your measure logic. If you are using functions like ALL(), REMOVEFILTERS(), or similar without carefully scoping them, your measure may be unintentionally bypassing the slicer's context.
Verify your data integrity if some counterparts have missing (NULL) trade dates or dates that fall outside your expected ranges (e.g., future dates), they will not behave correctly under slicer filters.
If you can share the measure DAX or a simplified view of your data model, I can assist you in narrowing down the exact issue.
Glad I could assist! If this answer helped resolve your issue, please mark it as Accept as Solution and give us Kudos to guide others facing the same concern.
Regards,
Sahasra.
5 Replies
- danextian
Super User
hi LFM
Welcome to the community! Please share sample data (not a screenshot), your expected result, and the reasoning behind. A link to an Excel file or a sanitized copy of your PBIX is fine (confidential data removed). Just as it takes time to prepare your sample data, it also takes time to come up with a solution.
v-sgandrathiCommunity Support
Hi LFM,
Thanks for reaching out to the Microsoft Fabric Community forum.
If your slicer is directly targeting the Trade Date, ensure that the Trade Date field has an active relationship with your fact table. Without an active relationship, the slicer will not filter the data as expected. Implementing a dedicated Date Dimension is highly recommended if not already in place.
Review your measure logic. If you are using functions like ALL(), REMOVEFILTERS(), or similar without carefully scoping them, your measure may be unintentionally bypassing the slicer's context.
Verify your data integrity if some counterparts have missing (NULL) trade dates or dates that fall outside your expected ranges (e.g., future dates), they will not behave correctly under slicer filters.
If you can share the measure DAX or a simplified view of your data model, I can assist you in narrowing down the exact issue.
Glad I could assist! If this answer helped resolve your issue, please mark it as Accept as Solution and give us Kudos to guide others facing the same concern.
Regards,
Sahasra.- v-sgandrathi
Hi LFM,
As we have not received a response from you yet, I would like to confirm whether you have successfully resolved the issue or if you require further assistance.
If the issue has been resolved, please mark the helpful reply as a "solution" to indicate that the question has been answered and to assist others in the community.
Thank you for your cooperation. Have a great day.- v-sgandrathi
Hi LFM,
May I ask if you have gotten this issue resolved?
If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.
Thank you.
