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
v-frfei-msft's avatar
v-frfei-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous ,

 

What is your excepted output?

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thank you for asking.

    Every month or year the data keeps changing and there can be a value in the Service line say "Accounting"  this month but next month this may be blank. Similarly, the location say "Mexico" may have value or may not have value. So, I would like to know a way to filters/ hide/not show blank rows and columns. 

     

    Accounting and Mexico are just for example and I cannot use hardcoded formulas that refers to just one country or service line :

    example: 

    Measure = SUMX('Value', IF(RELATED(Country[Country]) = "France", BLANK(), 'Value'[Value]))
     
    Let me know if this helps. Sorry for the confusion. I just started using Power BI.
     
    Regards

     

     

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

      Anonymous ,

       

      If the column/row is entirely blank, the visual will hide it by default.

       

      Ricardo

      • v-frfei-msft's avatar
        v-frfei-msft
        Icon for Community Support rankCommunity Support
        6 years ago

        Hi camargos88 ,