Forum Discussion
Supress Duplicate rows in visualisation
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
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
2 Replies
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
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
