Skip to main content

Power BI

Needs Votes

Quick measure for replacing blanks

Vote (2) Share
's profile image

on 11 Jan 2018 00:23:48

Some visuals, e.g. the line chart, doesn't show nice graphs in case of blanks. Instead of adding a measure in the data model just to fix this, it would be better if it was possible to use a quick measure

%Value (With No Blanks) =
VAR Value=[ValueThatCanBeBlank]
RETURN(
IF(
NOT(ISBLANK(Value));
Value;
0 //Or any other value to replace a blank
)
)