Hiding rows

[Anonymous]

HI Team,

We are trying to hide the rows with no values but  not able to acheive. we have Amount and %REV  rows and for %REV , and we want to hide those %REV rows which has no values   . Any suggestions are much appreciated ...

 

Thanks,

Chiranjeevi K.

[ibarrau]

Hi, you can change this by filtering the matrix avoiding blank values on the rows. If this doesn't work, the problem could be on the measure that has a hardcoding formula like "COUNT(Table[column]) + 1". The "+1" can take this effect. You may want to recheck your formula.

Regards,

[Anonymous]

Thanks for your  suggestion @ibarrau  ....we have tried using filter condition to remove blanks but thats filtering all the values and we are not getting any value ..you can have a look into DAX once                                                             

% of REV:=
IF (
AND (
AND (
AND ( [IsFilteredAccount] = FALSE (); [IsFilteredE] = FALSE () );
[IsFilteredGroup] = FALSE ()
);
[IsFilteredCostCenter] = FALSE ()
);
DIVIDE (
[Cumulative Total];
DIVIDE (
CALCULATE (
SUM ( General[Amount] );
FILTER (
ALLEXCEPT ( Account; Account[AccountGroup]; Account[Ecode];
Account[EGroup] = "31"
)
);
1000
)
);
BLANK()
)

Thanks,

Chiranjeevi K.

[v-shex-msft]

HI @Anonymous,

AFAIK, power bi will auto hide fields which has blank value on each fields(whole row/column blank records).

Maybe you can try to write a measure with if statement to hide specific values to keep non records on specific row, it will be hired by matrix itself.

Regards,

Xiaoxin Sheng