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.
Super UserIt'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 ResidentI had high hopes but I the options you mention don't appear for me...