Forum Discussion
cathoms
Responsive Resident
5 years agoMatrix Rows with duplicate values
I have data on provider office visit codes and need to show utilization rates of those codes. The dataset includes a column for provider names and a unique identifier for providers called NPI. Howeve...
- 5 years ago
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.
jdbuchanan71
Super User
5 years agoYou might have to turn on the "unsupported" features. File > Preferences: