Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hiding rows

  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 sugge...
Need Help
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
7 years ago

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.

 

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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