Skip to main content
Microsoft Idea

    Power BI

    Needs Votes

    Add checking on BLANK for Cadr visual

    Vote (407) Share
    's profile image

    on 10 Oct 2016 22:25:48

    Add to Card checking on Blank values and setting some custom values e.t. 0
    Now we must create special measures with IF(ISBLANK..
    But it makes 0-values fields

    Comments (55)
    's profile image Profile Picture

    Ben McMaster on 10 Feb 2023 01:45:11

    RE: Add checking on BLANK for Cadr visual

    I'm hoping an Admin won't close this telling us to create a Measure for it. We don't want additional measures, we just want the simple toggle box in the Card options.

    's profile image Profile Picture

    Ming Ye on 07 Jul 2022 06:58:42

    RE: Add checking on BLANK for Cadr visual

    I totally agree that we can replace the "(Blank)" text with measure and DAX tricks, but when we need the ID to implement drill through functionality, we could have some problem.

    's profile image Profile Picture

    on 20 Jun 2022 23:32:20

    RE: Add checking on BLANK for Cadr visual

    Right now, if you plot a measure that has blank values as a line-graph, you get a gap. This makes sense in some cases, but it would be nice to have an option in the visual to change blanks to zero's (this goes also for other visuals, such as cards where you might want to show revenue of 0 instead of blank).

    I know you can check in your measure with DAX if the value is 0, but it would be easier if it is a checkbox in the visual.

    's profile image Profile Picture

    on 20 Jun 2022 23:32:20

    RE: Add checking on BLANK for Cadr visual

    It would be great to have ability to change the word displayed when the value is (Blank) in a multi-row card. Having blocks of (Blank) values can be difficult to read data. Sometimes it is useful to replace it with other value e.g. N/A or empty string.

    's profile image Profile Picture

    on 20 Jun 2022 23:32:20

    RE: Add checking on BLANK for Cadr visual

    Any count that comes up empty should return an answer as 0 and not (Blank). A count should return a whole number.

    's profile image Profile Picture

    Paul Cully on 09 Jun 2022 15:28:56

    RE: Add checking on BLANK for Cadr visual

    Really still need this feature.I am not sure how many votes it requires. It seems like such a simple fix. Avoid having to create potentially hundreds of measures to just turn 'Blank' to '0'

    's profile image Profile Picture

    Muhammad Azber Bin Mohammad Safdar on 05 Aug 2021 06:42:11

    RE: Add checking on BLANK for Cadr visual

    Almost 5 years already. How much votes needed to start solving this ISSUE?

    's profile image Profile Picture

    on 22 Jun 2021 22:39:08

    RE: Add checking on BLANK for Cadr visual

    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 () .

    's profile image Profile Picture

    Andrew Tuplin on 14 Apr 2021 22:26:11

    RE: Add checking on BLANK for Cadr visual

    It's suuuuuper annoying having to create special measures that replace blanks with 0s. Given how common this is, it would be very helpful to have the Card Viz have an option to replace (blank) with some user supplied default value.

    's profile image Profile Picture

    Danny Power BI User on 14 Apr 2021 13:09:58

    RE: Add checking on BLANK for Cadr visual

    This really needs to be fixed asap.
    Adding +0 to a measure is fine if the measure was created in PBI but I have close to 100 fields in my model; that's an additional 100 measures just to remove (Blank).
    I wouldn't mind so much but if I click on the table view its showing as 0!!

    Merged Idea (3)