Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Hiding blank rows & Columns

Hello All, I would be grateful if someone can let me know a way to hide blank rows and columns in a matrix visualization of Power BI. Service-line and country are columns from a table but the value...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago
No automatic way to hid columns that I know of.
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Is there a query or any other way to hide blank rows or columns?

  • camargos88's avatar
    camargos88
    Icon for Community Champion rankCommunity Champion
    6 years ago

    Hi Anonymous ,

     

    I have a situation like that:

     

    Which operation are you doing ?

     

    Measure = SUMX('Table (2)'; IF('Table (2)'[Country] = "Mexico";BLANK(); 'Table (2)'[Value]))
     
    Ricardo
    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      I wrote the below measure:

       

      BlankRows = filter('values','values'[Service Line] = BLANK()) but this gave me below error:

      Function RELATED expects a fully qualified column reference as its argument

       

      Values is the table and Service line is a column within the table.

      • camargos88's avatar
        camargos88
        Icon for Community Champion rankCommunity Champion
        6 years ago

        Anonymous ,

         

        Can you provide some data sample ?

         

        Ricardo