Forum Discussion
how to show duplicate rows/columns in Matrix
In Power BI, you can use the "expand" feature in the "modeling" tab to show all the duplicated rows in the matrix. To do this, select the column that you want to expand, go to the "modeling" tab, and click the "expand" button. This will create a new table with all the duplicated rows.
You can then add this new table to your matrix visualization and it should show all the duplicated rows in level 1.
Alternatively, you can use a "pivot table" visualization instead of a matrix to achieve the same result. To create a pivot table, select the column that you want to use as the rows of the pivot table, and then drag and drop any additional columns that you want to include as columns or values. This will create a pivot table that shows all the duplicated rows in level 1.
- binayjethwa3 years ago
Helper V
Hi MAwwad where exactly is the expand option in modelling tab and how will it create a new table.
I tried below and nothing showed up.
so basically i have hierarchial data where level 1 , level 2 etc can have same names and duplicates , but i want those duplicates to be visible and not grouped by as power bi does by default. is this possible ?