Slicer with dates wont filter out values before a certain date

[LFM]

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?

[v-sgandrathi · Accepted solution]

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.

[v-sgandrathi]

Hi @LFM,

I wanted to check in your situation regarding the issue. Have you resolved it? If you have, please consider marking the reply as Accepted solution and give Kudos that helped you. It would be greatly appreciated by others in the community who may have the same question.

Thank you.

[danextian]

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.