Forum Discussion
matrix visual show all values
Hi
I have underlying data liek this
Date| Action| Time|
2023-06-29|IN|08:00|
2023-06-29|OUT|12:30|
2023-06-29|IN|15:00|
I want oto create the folowing visual(i am trying matrix)
Date|IN|OUT|IN
2023-06-29|08:00|12:30|15:00|
But if i do like this in visual
putin time in values it says earliest time and removes data:
How do i show all values?
Hi jja ,
Here are the steps you can follow：
1. In power query – Group By.
2. Add Column – Custom Column.
Table.AddIndexColumn([Group1],"Index",1)3. Select [Customer] – click the double arrow to expand the sign – select [Action], [Time], [Index].
4. Select [Group1] -- Remove.
5. Select [Action] , [Index] – Merge Column.
Result:
Refer to:
Create Row Number for Each Group in Power BI using Power Query - RADACAD
6. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
1 Reply
Hi jja ,
Here are the steps you can follow：
1. In power query – Group By.
2. Add Column – Custom Column.
Table.AddIndexColumn([Group1],"Index",1)3. Select [Customer] – click the double arrow to expand the sign – select [Action], [Time], [Index].
4. Select [Group1] -- Remove.
5. Select [Action] , [Index] – Merge Column.
Result:
Refer to:
Create Row Number for Each Group in Power BI using Power Query - RADACAD
6. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly