Hide blank values of a single measure in a matrix

[Anonymous]

Hello everyone, 

I would like to ask your wisdom in hiding blank columns in a matrix, but with many columns. I have made the example in excel and the goal is to hide Col2 when it's empty. 

https://www.dropbox.com/s/8zoib2ek2hakmno/Sample%201.xlsx?dl=0

Also, can you help me with creating a column based that matches table dates? 

To see this result. 

Thank you in advance

[Anonymous]

Gracias for your answer!

This is the Sample in PowerBI.

https://www.dropbox.com/s/9fdjb5xagtqyy5d/Sample%201.pbix?dl=0

I think I can't use that because are the value/measure (not a category) what I should hide.  

[amitchandak]

@Anonymous , is it analyze in excel? 

I do not see any pbix. Ideally power bi suppresses blank , rows unless you use an option like this or add +0 to measure. If you have use below option then uncheck that