Forum Discussion
Show/Hide Matrix Columns When Collapsed or Expanded
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.
5 Replies
- PC2790Community Champion
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/ideas/idea/?ideaid=2e2e91df-b512-4887-a7a7-6b0615570578
- MikePowerBIHelper II
- AnonymousNot applicable
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.- MikePowerBIHelper II
Hi Anonymous
Thank you for your input! That's a good trick to have for some other scenerios.
- AnonymousNot applicable
Try using this formula
No. Records = IF( ISINSCOPE( [INV RECORDS #), BLANK(), SELECTEDVALUE( [No. Recrods]) )