How to Hide empty Columns in Matrix visual?

[yodha]

Hi, is there a way to hide empty columns in matrix visual ?

i wanted to hide highlighted columns,

Attached pbix for reference https://www.dropbox.com/s/qllt34kyfcy38gg/Power%20BI%20Example.pbix?dl=0

Thanks in Advance.

[v-yingjl · Accepted solution]

Hi @yodha ,

You can define the size of the column so you can hide then until is invisible just drag the border of the column, be aware that you may need to turn off word wrap on the options on column headers.

Best Regards,
Yingjie Li

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

[yodha]

@v-yingjl : Thanks for the reply. This is not best way to do, atleast in my case. Many columns are there in my original PBIX and i do refresh daily this report. So when i refresh columns will come back to normal position. 

[v-yingjl]

Hi @yodha ,

If you've fixed the issue on your own please kindly share your solution. If the above posts help, please kindly mark it as a solution to help others find it more quickly. Thanks!

Best Regards,
Yingjie Li

[amitchandak]

@yodha , create a measure using allexpect and put that into the visual level filter

calculate([Measure],allexpect (Table[Month Year]) // is not blank

https://www.sqlbi.com/articles/using-allexcept-versus-all-and-values/

[yodha]

@amitchandak : Thanks for the reply, i just tried this solution but it's not working.

 

[tex628]

Do you have this setting applied? 

[yodha]

@tex628 :Thanks for the reply. Yes,this setting is already applied.

[Tahreem24]

@yodha ,

You can show 0  instead of empty row.

Total  = Sum(Table[Sales])+0

OR

Total = Your Measure+0

[yodha]

@Tahreem24 :No, i can't do this. Thank you

[tex628]

Try this:

Measure = 
IF( (Calculate([Total Cost] ALLEXCEPT(Table ; Table[date])) + Calculate([Total Forecast]; ALLEXCEPT(Table ; Table[date])) = BLANK() ; BLANK() ; [Cumulative Total])

And replace the Cumulative total measure with this. 

/ J

[yodha]

@tex628 : i have tried this, but this is removing entire month, but i want to remove only empty columns in the month. Thank you.

[tex628]

That is sadly not possible. When you're using several measures as values in a matrix the columns will always be present as long as there is atleast 1 value that isn't blank(). It's either hide the entire month because the two first measures are empty or show all 3 columns. 

/ J