Values are not repeated in columns

[Syndicate_Admin]

I am trying to get certain values in a table for years, but that some of them come out only once, do not repeat for each year, would you know how to do it?

It would be to leave this table

in something like that, where the values marked in red would only be once and would not be repeated per year

2016

2017

No

Description

Unit Cost

Unit Price

Net sales

Unit_Cost

Unit_Price

Margin%

Unit Price

Net sales

Unit_Cost

Unit_Price

Margin%

[v-rzhou-msft · Accepted solution]

Hi @Syndicate_Admin ,

As far as I know, you add multiple columns into matrix value fields, so Power BI will expand each value part by column fields. EX: 2016 has 7 columns and 2017 will has 7 columns as well.

According to your statement, I think you want to remove some columns which is expanded in column field. 

I suggest you to turn off the word wrap and reduce the width of the columns which you don't need to 0.

Here I reduce the width of [Unit Price] and [Net sales] in 2016 to 0.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.