Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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,
Happy to help!
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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |