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
1 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
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
