Power BI Exclude All Zero columns on Matrix Table

[alanuxx]

Hello Everyone , 

I have fact table which has columns like this . There are 2 description table of branches and products . 

i am using Matrix Table component . As you can see below picture  The number of 118,119 and 12 branches are on Branch table but there is no data for the choosen filter(There is no data for Month_id=202306  filter ) .  İ would like to exclude all zero columns like this .  Only Branch code  1 and Branch code  2 should be shown on the matrix . 

How can i do that ?

Regards 

[danextian · Accepted solution]

Hi @alanuxx ,

Whatever measure you use in the Values tile of your matrix should return blank if there's no value at all. If the data is zero, it will be returned as zero. As a workaround, you can use a measure like below

New Measure =
IF ( [Current Measure] = 0, BLANK (), [Current Measure] )

and use this in your matrix instead.

[alanuxx]

It worked .Thank you so much.