Group in Matrix Visual

[Anonymous]

Good morning,

I made a Matrix Visual that should show per day, per ressource the times where the ressources (lets call them people ^^)  come and go.

My Problem ist, that they come and go a couple of times per day (lunchbreak for example) and the visual always groups per Date.

I would like something like this:

Date	RessourceNr	Beginning	End
01.01.2019	1	08:00	12:00
		13:00	17:00
	2	08:00	12:00
		13:00	17:00
02.01.2019	1	08:00	12:00
		13:00	17:00
	2	08:00	12:00
		13:00	17:00

and what I get is more like:

Date	RessourceNr	Beginning	End
01.01.2019	1	08:00	12:00
	2	08:00	12:00
02.01.2019	1	08:00	12:00
	2	08:00	12:00

If anybody could help me, it would be much appreciated.

[amitchandak]

You do not want data for the period -

13:00

17:00

Then you can use the visual level filter. Or you want to group some data from the above period with 8:00 -12:00 Data period?

[Anonymous]

I want all the data. So if I have multiple Beginnings and Ending I want to see them all, but they always seem to group per Date/Ressource

[v-lid-msft · Accepted solution]

Hi @Anonymous ,

we can create a index column depends on the date and resource to meet your requirement.

Index =
VAR d = [Date]
VAR nr = [RessourceNr]
RETURN
    RANKX (
        (
            FILTER ( 'Test', AND ( 'Test'[Date] = d, 'Test'[RessourceNr] = nr ) )
        ),
        [Beginning],
        ,
        ASC
    )

You can use other unique column to archive same goal.

BTW, pbix as attached.

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Thank you very much, I just have one more Problem. The Matrix only shows me the first Value that I put in Row (sorry its all german).

I worked with a Matrix before and it worked perfectly and now Ic ant seem to find an Option or the source for the Problem.

[v-lid-msft]

Hi @Anonymous ,

I am sorry for my unclear answer, you can use the expand button to get the full table.

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.