Forum Discussion

alanuxx's avatar
alanuxx
Frequent Visitor
3 years ago
Solved

Power BI Exclude All Zero columns on Matrix Table

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 

 

Need Help
  • danextian's avatar
    danextian
    3 years ago

    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.

2 Replies

  • danextian's avatar
    danextian
    Super User
    3 years ago

    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.