User/Hours ; Date Slicer is removing users even with "Show items with no data" selected

[ZSBolt4]

Using list of work log users and values of Hours.  I want to see how many hours this month per the list of users.  However I can never see users with 0 timestamps within the month.  How do I make the list of users static and just update the hours when selecting my dates?

3 sets of data: Timestamp, Hours, Users.  Users enter hours and hours have a timestamp.  Sometimes users don't enter any hours and I want to catch those. 

[Anonymous · Accepted solution]

Hi @ZSBolt4 

You can refer to the following solution

Sample data 

Date table

Relationship

1.Create a user table to just input user to it.

2.Then can create a measure

Measure =
VAR a =
    CALCULATE (
        SUM ( 'Data'[hours] ),
        FILTER ( 'Data', [User] IN VALUES ( 'User'[User] ) )
    )
RETURN
    IF ( NOT ( ISBLANK ( a ) ), a, 0 )

3.Then create a column visual and put the user field of the user table to x-axis, and the measure to the y-axis

Output

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
If you are unsure how to do that please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

If you want to get answers faster please refer to https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...