topic how do i fix dax slicer to show the values properly in DAX Commands and Tips

how do i fix dax slicer to show the values properly

anonymous2967 — Mon, 07 Apr 2025 12:22:08 GMT

I have three tables in the model: Date, Targets, and Users. A sample is attached for reference. The relationships are set up as follows:

Target[Effectivedatekey] to Date[Datekey] (one-to-many, single direction).
Target[Agentkey] to Users[Agentkey] (many-to-one, both directions).

The Power BI report includes three slicers:

Reporting Period: Relative date slicer.
Period: Hierarchy slicer (refer to the attached image).
Name: from the Users table.

Issue:

When I select "Weekend Date" from the Period slicer, no results are returned in the Users[Name] slicer.

Proposed Solution:

When selecting "Weekend Date" from the Period slicer, automatically select the corresponding Month-End Date. Then, filter both the Targets and Users tables to return the relevant values in the Users[Name] slicer.
I donot want to change the targets to weekly .

Re: how do i fix dax slicer to show the values properly

lbendlin — Mon, 07 Apr 2025 21:09:59 GMT

Target[Effectivedatekey] to Date[Datekey] (one-to-many, single direction).

that's the wrong direction.

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Re: how do i fix dax slicer to show the values properly

anonymous2967 — Tue, 08 Apr 2025 05:54:32 GMT

https://drive.google.com/file/d/1O5tyHAUivXwMrpODyQIeQODE8QcdFMl-/view?usp=drive_link

Re: how do i fix dax slicer to show the values properly

anonymous2967 — Tue, 08 Apr 2025 06:01:30 GMT

I have attached a sample PBIX file for reference. The expected output is as follows: when any date is selected from the second slicer (Period slicer), if the user has a corresponding target as of the Month-End Date, the username should appear in the slicer.

Currently, usernames are only appearing in the slicer if Month-End Dates are selected from the Period slicer. This is because the Targets table only contains Month-End Dates.

Re: how do i fix dax slicer to show the values properly

anonymous2967 — Tue, 08 Apr 2025 10:00:52 GMT

https://drive.google.com/file/d/1O5tyHAUivXwMrpODyQIeQODE8QcdFMl-/view?usp=drive_link

Re: how do i fix dax slicer to show the values properly

lbendlin — Tue, 08 Apr 2025 20:26:28 GMT

I corrected your date hierarchy - note that it is not strictly required as the slicer visual can handle multiple fields.

Your calendar table is not long enoug, it does not cover the second target.

Re: how do i fix dax slicer to show the values properly

v-pnaroju-msft — Sat, 12 Apr 2025 18:01:50 GMT

Thankyou, lbendlin, for your response.

Hi anonymous2967,

We would like to check if the solution provided by lbendlin has resolved your issue. If you have found an alternative approach, we encourage you to share it with the community to assist others facing similar challenges.

If you found the response helpful, please mark it as the accepted solution and add kudos. This recognition benefits other members seeking solutions to similar queries.

Thank you.

Re: how do i fix dax slicer to show the values properly

v-pnaroju-msft — Tue, 15 Apr 2025 12:18:18 GMT

Hi anonymous2967,

We wanted to check in regarding your query, as we have not heard back from you. If you have resolved the issue, sharing the solution with the community would be greatly appreciated and could help others encountering similar challenges.

If you found our response useful, kindly mark it as the accepted solution and provide kudos to guide other members.

Thank you.

Re: how do i fix dax slicer to show the values properly

v-pnaroju-msft — Sat, 19 Apr 2025 17:34:59 GMT

Hi anonymous2967,

We are following up to see if your query has been resolved. Should you have identified a solution, we kindly request you to share it with the community to assist others facing similar issues.

If our response was helpful, please mark it as the accepted solution and provide kudos, as this helps the broader community.

Thank you.