Skip to main content

    Power BI

    Needs Votes

    When Blank () function is used in DAX it should return nothing instead of word (blank)

    Vote (241) Share
    's profile image

    on 26 May 2016 19:54:12

    Why would we want the work (blank) shown if we specifically said in our formula to return Blank () . Also know as nothing, nada, zilch. There should be nothing shown if we say we want it to return Blank () .

    Comments (15)
    's profile image Profile Picture

    1f1c7cd6 65af-4e22-b96e-6f4f98fb8f9c on 05 Jul 2020 23:39:19

    RE: When Blank () function is used in DAX it should return nothing instead of word (blank)

    This is an absolute must if it is a count, the number 0 should appear.

    's profile image Profile Picture

    883a137a 9568-402c-9eef-bd06fc587760 on 05 Jul 2020 23:30:02

    RE: When Blank () function is used in DAX it should return nothing instead of word (blank)

    This is very necessary. Technically blank is not equal to 0, so that the work around so far to not see the blank work is not good enough. We just need the ability of change the word display here. And FYI - the other BI tools have this functionality...

    's profile image Profile Picture

    d7df5801 98b2-49e0-b76c-3eae1261b9ee on 05 Jul 2020 23:17:31

    RE: When Blank () function is used in DAX it should return nothing instead of word (blank)

    Very frustrating to design measures around this concept to not show the word blank. I think a toggle option on the individual KPI would work just fine or just assuming we don't want the visual to show (Blank). No client wants to see that

    's profile image Profile Picture

    cbaf833d 6ac6-4de2-9ff5-ab44fd9d5f0c on 05 Jul 2020 23:10:22

    RE: When Blank () function is used in DAX it should return nothing instead of word (blank)

    Agree...should be the option to show 0 or nothing

    's profile image Profile Picture

    b5882711 5819-e611-80e2-c4346bad91c4 on 05 Jul 2020 22:57:30

    RE: When Blank () function is used in DAX it should return nothing instead of word (blank)

    Why is MS not commenting on this?

    's profile image Profile Picture

    6a058b1f 473c-4053-aca8-a85f5d4019dc on 05 Jul 2020 22:49:57

    RE: When Blank () function is used in DAX it should return nothing instead of word (blank)

    I think the visual should have a "hide when blank () " Option. Requires clear communication during development:
    A message box should apper in the editor (1 visual is currently hidden because the value is blank and the "hide if blank" option is on.)

    's profile image Profile Picture

    f5883dd2 453c-4b84-baad-b8ef905bce33 on 05 Jul 2020 22:36:47

    RE: When Blank () function is used in DAX it should return nothing instead of word (blank)

    I would like to also add to give the option to shown nothing or 0.

    's profile image Profile Picture

    5dc3e78d 80d0-4ff8-b584-1856d97d9cd7 on 05 Jul 2020 22:29:51

    RE: When Blank () function is used in DAX it should return nothing instead of word (blank)

    Absolutely agree

    's profile image Profile Picture

    d041d6c7 04a2-408e-b7da-6690e7f090d9 on 05 Jul 2020 22:27:16

    RE: When Blank () function is used in DAX it should return nothing instead of word (blank)

    I agree that this should be an option for ease of use.

    A workaround I have found when creating measures is to wrap in an IF statement testing for BLANK () and then using the IF statement to assign the value I want.

    's profile image Profile Picture

    d966217b 68fd-48c7-9355-fa9087a7352d on 05 Jul 2020 22:25:39

    RE: When Blank () function is used in DAX it should return nothing instead of word (blank)

    100% agree