How to hide -100% values

[o59393]

Hi all

The dax "Detlta Growth" works well, the issue is with the -100% that I cannot hide as seen below:

Delta Growth = 

DIVIDE(SUM('Append OU Demand'[OU Demand])-[LY OU Demand],[LY OU Demand],BLANK())

Problem might be because of the "LY OU demand" measure that returns (correctly) the previous date demand as seen for 2026:

How can I hide the -100% values from the table to have something like this below (without showing 2026)?

Thanks.

[sevenhills · Accepted solution]

Try this, as you have not uploaded .pbix, just a guess: You are trying to hide either for future dates and/or SUM([OU Demand]) has no value. Try to change somewhat like below to all measures. 

       IF Statement, BLANK(), Calculated value. i.e., if Statement and calculation formula varies for each measure. 

Delta Growth = 
VAR _R = DIVIDE(SUM('Append OU Demand'[OU Demand])-[LY OU Demand],[LY OU Demand],BLANK())

RETURN IF ( _R = 1.00, BLANK(), _R)

Not complete solution, but giving the steps 🙂

[Ritaf1983]

Hi @o59393 

please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly