Forum Discussion
Helper IIhow to remove repeated rows in table
I have the table below. I want to remove repeated data. I want the data to appear only once per row, even if a column has multiple entries. I don’t want the same data to be repeated on every single row unless differnet. it should be empty as I highlighted in yellow.
5 Replies
- MasonMA
Super User
Hi,
Use 'Matrix' visual instead of Table visual.
Then in Matrix visual, place all Columns in Rows. In Format, switch off the '+/- icons' under Row headers and choose right Layout as in below.
adnankabinaThanks for your reply I have too many column when I add them all it removes scrollbar I do not know why
- MasonMA
Hi,
I tested and i'm seeing the same issue. The only few ways i could come up with are manually adjusting the column width or changing the canvas resolution so that it gives you more spaces.
You may wait and see if other users have better suggestions. If not it would be a bug and you may consider submitting an idea on platform to MS.
ryan_mayulike what MasonMA mentioned, you can submit feedback to Microsoft.
Create a Fabric and Power BI Support Ticket - Power BI | Microsoft Learn
v-echaithraCommunity Support
Hi adnankabina ,
Thank you for reaching out to Microsoft Fabric Community.
Thank you ryan_mayu , MasonMA for the prompt response.
Kindly confirm whether the issue has been resolved by raising the support ticket, or if further assistance is still required. We are available to support you.
Thank you.
