Slicer issue with weekend date selection

[anonymous2967]

Current Situation: I have four tables: KPI, Date, Users, and Contact, and I have added sample data to my Power BI file. 
Currently, when I select a month (e.g., March), the usernames are listed in the slicer. However, if I select any weekend date, the usernames do not appear.
 
What Needs to Be Done: Usernames should appear in the slicer if the user has targets for the selected month.
 
Given that modifying the table data could be complicated in my scenario, I would appreciate it if this could be handled using DAX.

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

[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]

Hi anonymous2967,

We have not received a response from you regarding the query and were following up to check if you have found a resolution. If you have identified a solution, we kindly request you to share it with the community, as it may be helpful to others facing a similar issue.

If you find the response helpful, please mark it as the accepted solution and provide kudos, as this will help other members with similar queries.

Thank you.

[v-pnaroju-msft · Accepted solution]

Thankyou, @GrowthNatives, for your response.

Hi anonymous2967,

We appreciate your inquiry posted on the Microsoft Fabric Community Forum.

Kindly find attached the screenshot and the PBIX file, which may assist in resolving the issue:

If you find our response helpful, please consider marking it as the accepted solution and kindly provide kudos. This will help other community members who may have similar queries.

Thank you.

[GrowthNatives]

Hi @anonymous2967 ,
I understand that you are facing a slicer issue with weekend date selection, to the best of my understanding, the issue you're facing is due to how the slicer reacts when weekend dates (which might not have data) are selected, even though users have KPI targets within that month.

The DAX solution I am sharing should help. However, since I haven’t seen your actual Power BI file and data structure, it would be much better if you could provide access via Google Drive. That way, I can review it more accurately.

💭 Assuming:

• KPI table includes columns: UserID, Date, Target

• Users table includes: UserID, UserName

• Date table includes: Date, Month, Day, IsWeekend (optional)

• Relationship:

  • KPI[Date] → Date[Date]

  • KPI[UserID] → Users[UserID]

  • Contact is not directly relevant unless it filters users
    
    

✅Calculated Table DAX Solution (for Slicer):

Create a new table for slicer that only includes users with a target in the selected month:

UsersWithMonthlyTarget = 
VAR SelectedMonth =
    SELECTEDVALUE('Date'[Month]) -- or use MonthNumber or Month-Year as needed
RETURN
FILTER (
    Users,
    CALCULATE (
        COUNTROWS (KPI),
        FILTER (
            KPI,
            MONTH (KPI[Date]) = SelectedMonth
            && NOT ISBLANK(KPI[Target])
        )
    ) > 0
)

This ensures that only users with a KPI target in the selected month will show in the slicer, even if a weekend date is selected.

💡 Alternative (If Using Measure Instead in Visual):

If you want to keep your existing slicer but make usernames appear even when weekends are selected, you can modify the filtering behavior using a measure like:

HasTargetThisMonth = 
CALCULATE (
    COUNTROWS (KPI),
    FILTER (
        KPI,
        MONTH (KPI[Date]) = MONTH(SELECTEDVALUE('Date'[Date]))
            && NOT ISBLANK(KPI[Target])
    )
)

Then filter the slicer using a visual-level filter: HasTargetThisMonth > 0

Notes:

• This won't require any change to the underlying data model or relationships.

• Works dynamically with your existing slicers for date/month.

• If your Date table has Month-Year, use that for better precision (not just month number).
  
  

⭐Hope this solution helps you make the most of Power BI! If it did, click 'Mark as Solution' to help others find the right answers.
💡Found it helpful? Show some love with kudos 👍 as your support keeps our community thriving!
🚀Let’s keep building smarter, data-driven solutions together! 🚀

[anonymous2967]

Thanks for the prompt reply.  I have tried the above solutions provided , however it didnt work. 

Sorry I have now provided the required access to download the sample pbix file and source files to view the datamodel.  Looking forward for your response.

https://drive.google.com/drive/folders/1BFTfeAel32M9AnVJcc7iwleTdqcd_gzr?usp=drive_link

[anonymous2967]

Hi, Thanks for the prompt reply. I have now attached model and relationship screenshots.

Also provided sample files with download permission to the google drive link. Could you please check and let me know.

https://drive.google.com/drive/folders/1BFTfeAel32M9AnVJcc7iwleTdqcd_gzr?usp=drive_link

[anonymous2967]

@GrowthNatives  are you able to access the folder and do you have any solution for this .