Forum Discussion

snaseem's avatar
snaseem
Icon for Helper I rankHelper I
3 years ago
Solved

Hide Empty Columns in a Matrix based on Conditions

In below screenshot, I want to hide columns when they are empty based on the conditions.

As an example, If my GLAccountId (first three digits) is less than 900, the empty columns that show "Allowable" should be hidden

and when the value is greater than 900 (complete format 900-xxx-xxx), all empty columns that show "Unallowable" should be hidden.

 

Allowable and Unallowable are my measures based on certain conditions.

 

 

 

I can't share the PBI file, sorry!

 

Thanks,

 

amitchandak 

Greg_Deckler 

Data-Rainer 

tamerj1 

 

 

  • HI snaseem , unfortunately, it is not possible to conditionally hide columns.

     

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

1 Reply

  • HI snaseem , unfortunately, it is not possible to conditionally hide columns.

     

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