Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

hide column when it is blank

Hi, I need to hide one column but show its column total in Matrix visual. I am able to acheive when it just one value but when multiple values added it showing the column custom_measure even when it is blank, column hide should be based on the measure not grab and close the column manually. Here is my measure. I need to acheive table 2. thanks

 

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous ,

     

    Thanks for the reply from lbendlin , please allow me to provide another insight:

     

    As you said, columns do not support hiding based on measure for now. It can only be hidden by column fields via show item with no data.

     

    Best Regards,
    Adamk Kong

     

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

     

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable

      no, this is not working for me

      even removed column/row subtotal since it had data for custom_Measure

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous ,

     

    Then as lbendlin said, you can raise a idea.

     

    Best Regards,
    Adamk Kong