Supress Duplicate rows in visualisation

[f1rich]

Hi, 

Hope you can help me here... 

I would like to supress duplicate rows if it's possible? Via DAX . I am aware of Power Query having remove duplicates but I would like to keep them, I just need to supress the duplicates or group them, whichever is the best method. 

At the moment i have something like:

Number	Date	Property	Watch	Area	Vehicle	Mob
123	01/06/2022 10:00	House	Red	Sheffield	Appliance 1	01/06/2022 10:05
123	01/06/2022 10:00	House	Red	Sheffield	Appliance 2	01/06/2022 10:06
129	05/06/2022 10:00	Boat	White	Doncaster	Appliance 1	05/06/2022 10:05
131	10/06/2022 10:00	Hospital	Green	Rotherham	Appliance 1	10/06/2022 10:05
131	10/06/2022 10:00	Hospital	Green	Rotherham	Appliance 2	10/06/2022 10:06
131	10/06/2022 10:00	Hospital	Green	Rotherham	Appliance 3	10/06/2022 10:07

What I want to see in the visuilasation is:

Number	Date	Property	Watch	Area	Vehicle	Mob
123	01/06/2022 10:00	House	Red	Sheffield	Appliance 1	01/06/2022 10:05
					Appliance 2	01/06/2022 10:06
129	05/06/2022 10:00	Boat	White	Doncaster	Appliance 1	05/06/2022 10:05
131	10/06/2022 10:00	Hospital	Green	Rotherham	Appliance 1	10/06/2022 10:05
					Appliance 2	10/06/2022 10:06
					Appliance 3	10/06/2022 10:07

Can this be done?

Thank you

[vanessafvg · Accepted solution]

use a matrix visual not a table visual and then it will automatically deduplicate in the visual if you stack all your columns under rows

[f1rich]

Thank you @vanessafvg .

I've totally forgotten about Matrix visualization. I think the reason why i have stopped using it in the past is because when you put all the fields into rows, there's no horizontal scroll bar, only vertical scroll bar. It's frustrating because i would like to adjust the columns 😞 

I think that's why i am using Table visualization because there's a scroll bar for both horizontal and vertical for me to adjust the columns