Hide / Remove unwanted columns

[colourfullife]

AHi,

I am looking for a solumtion to hide unwanted columns in 'Matrix' visual in PBI.

showing you what i have got and what i want it to be

this is the database that i have.

ITEM	Open/ Close
A	OPEN
B	OPEN
A	OPEN
B	OPEN
B	CLOSE
A	CLOSE
B	CLOSE
A	CLOSE
B	CLOSE

and this is my visual, using 'Matrix' --->

and attached how i get the value in the table.

what i want is i want to hide columns that i don't want which are %RT Count of ITEM for OPEN and TOTAL..!

do you guys have any ideas??

any advice would be much appreciated.

Regards,

CL

[v-gizhi-msft · Accepted solution]

Hi,

According to your description, here are two ways:

1)Try to turn the ‘Word warp’ button to ‘Off’ in Column headers in visual format setting.

Then wrap the column you do not want to the left side in order to hide its data:

You can display them again whenever you want just by wrapping them to the right side.

2)Create a measure to replace the %RT Count of Open/Close:

Measure

= IF("OPEN" in  FILTERS('Table'[Open/Close]),BLANK(),CALCULATE(COUNT('Table'[ITEM]))/CALCULATE(COUNT('Table'[ITEM]),ALLEXCEPT('Table','Table'[ITEM])))

Change its data format to percentage:

And it shows:

You can also wrap the measure to hide it.

Best Regards,

Giotto Zhi