how do i fix dax slicer to show the values properly

[anonymous2967]

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:

1. Reporting Period: Relative date slicer.

2. Period: Hierarchy slicer (refer to the attached image).

3. 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 .

[v-pnaroju-msft]

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.

[v-pnaroju-msft]

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.

[v-pnaroju-msft]

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.

[anonymous2967]

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.

[anonymous2967]

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

[lbendlin]

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-...
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

[anonymous2967]

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

[lbendlin · Accepted solution]

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.