cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kchiranj Frequent Visitor
Frequent Visitor

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 suggestions are much appreciated ...

 

 HidingRows .png

Thanks,

Chiranjeevi K.

3 REPLIES 3
Highlighted
ibarrau Established Member
Established Member

Re: Hiding rows

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,

kchiranj Frequent Visitor
Frequent Visitor

Re: Hiding rows

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.

 

 

Community Support Team
Community Support Team

Re: Hiding rows

HI @kchiranj,

 

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

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |