Hide Empty Columns in a Matrix based on Conditions

[snaseem]

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 

[Ritaf1983 · Accepted solution]

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