Forum Discussion

cathoms's avatar
cathoms
Icon for Responsive Resident rankResponsive Resident
5 years ago
Solved

Matrix 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...
  • jdbuchanan71's avatar
    5 years ago

    cathoms 

    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.