Forum Discussion
Solved
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 t...
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
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