Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Hide Columns in Matrix which have no values

Hi Dear Power BI-Community,

 

I need help to hide columns in my matrix which have no values. In my Screenshot you see the case:

 

The Black lines are line names, which I have coloured for privacy reasons.

The Yellow lines are gaps / blank lines for formatting purposes.

The Red column still I want to see in my matrix.

The Green columns I want to hide.

 

My attempt was something with IF(SELECTEDVALUE) / IF(HASONEVALUE) but with no success.

 

Thank you for your help.

 

 

Greetings Tim

Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    I have a solution:

     

    IF(ISEMPTY(<Table that is in Columns>),BLANK(),
    if(SELECTEDVALUE ( Rows ) = BLANK(),"⠀",Sales))

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    I have a solution:

     

    IF(ISEMPTY(<Table that is in Columns>),BLANK(),
    if(SELECTEDVALUE ( Rows ) = BLANK(),"⠀",Sales))