Forum Discussion
Responsive ResidentMatrix Rows with duplicate values
It's odd to me that the setting is not available in the default UI that I could find. If you download Tabular Editor
https://www.sqlbi.com/tools/tabular-editor/
You can open it from your .pbix file under external tools.
Once you have it open you can select your column and set the property of 'Keep Unique Rows' to true.
You will also have to identify the column that is the unique identifier for the table. In my example it is Product_Key:
This will stop the visual from grouping them together.
Responsive ResidentThis doesn't work right yet because my key column has duplicates. Turns out as an artifact of some merged or appended queries I have duplicate provider ids, but they are not duplicate rows (see image below) so I need to start another thread (see link below) to get help with that issue then circle back here.
Remove specific, partially duplicate rows
- jdbuchanan71
Super User
In PowerQuery you can add an index column and assign that as the key on the table.
- cathoms
Sure, but I still need to get rid of those duplicates I think.