Show/Hide Matrix Columns When Collapsed or Expanded

[MikePowerBI]

Hi there,

In my Power BI file I have a matrix with a site name and record number in the rows of the matrix. In the values of the matrix I have various fields. Is there a way within Power BI to hide specific columns in the values section of the matrix depending on if a row is expanded or collapsed? 

For example: when the matrix is collapsed, the No. of Records columns great. 

But I would like to hide this column when the matrix is expanded, since it is not as useful. 

[Anonymous]

Try using this formula 

No. Records = IF( ISINSCOPE( [INV RECORDS #), BLANK(), SELECTEDVALUE( [No. Recrods]) )

[Anonymous]

Hi @MikePowerBI ,

Agree with @PC2790 that your requirement could not be realized currently.

My workaround is : firstly reduce the width and then disable the "Text wrap" option to achieve a similar output as shown below:

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

[MikePowerBI]

Hi @Anonymous 

Thank you for your input! That's a good trick to have for some other scenerios. 

[PC2790]

I don't think that is a provision in Power BI currently.

However you can put this as an idea in Ideas Portal of Power BI.

I think there is a related one already present- https://ideas.powerbi.com/ideas/idea/?ideaid=2e2e91df-b512-4887-a7a7-6b0615570578ideas.powerbi.com/i...

[MikePowerBI]

Hi @PC2790 

Thanks for your input, I appreciate it!