Hide Columns with no data

Question

I have measure&nbsp;Measure=VAR val1 = IF (ISINSCOPE(Table1[Names]),BLANK(),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;FORMAT ( [MesureDivide], "0.00%" ))VAR val2 = [COGS]&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;RETURNSWITCH( SELECTEDVALUE(Table3[Surnames]),"Sales",&nbsp; &nbsp;val1,"COGS",&nbsp; &nbsp;val2,BLANK())&nbsp;But it return blanks or empty values which not hiding and not possible to filter&nbsp;&nbsp;&nbsp;How to hide thoose rows and columns? Problems seam with FORMAT functions, as without it everything work fine, but not showing %

anonymous · Answer

Hello&nbsp;Analitika&nbsp;,Instead of format try like this&nbsp;[MesureDivide] &amp;"0.00%"

analitika · Answer

AnonymousNot work as showing zeroes value&nbsp;&nbsp;

anonymous · Answer

Can you just check this&nbsp;[MesureDivide] and instead of format return this&nbsp;[MesureDivide] and check are you getting the expected value?

analitika · Answer

Then everything works instead of formating to %

Forum Discussion

Hide Columns with no data

4 Replies

Related content

Matrix table column Hide

hiding columns in Matrix

Hide column from a table visual

Hide column header on table

Hide visual