Power BI

Needs Votes

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

Vote (241)

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)

Comments (15)

027423da 2036-4f3a-a6ee-77d991892bec on 05 Jul 2020 22:24:55

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

can't you just replace all instances of blank with " " or does that not work

a8276610 6b80-49c3-8af8-9d2aab55b807 on 05 Jul 2020 22:24:37

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

It would be nice to be able to turn this on or off (probly default to off)...

7e402c36 7bbe-41f6-966a-779baef307a1 on 05 Jul 2020 22:23:49

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

It is really frustrating, does anybody reads this? Any idea why it started to appear there while in Desktop Designer it works just fine? When is it going to be fixed?

a3309361 99be-ea11-a812-000d3a8ddfb2 on 05 Jul 2020 22:22:28

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

I agree 100%. We have a table that looks terrible because it has "(blank)" showing up all over the place. In fact, it doesn't look good anywhere. It makes it very difficult to read. Put it back the way it was.

a3309361 99be-ea11-a812-000d3a8ddfb2 on 05 Jul 2020 22:22:28

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

Or give us the ability to turn it off/on within the visualization.