Forum Discussion
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 p...
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.
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.
It worked .Thank you so much.