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

Power BI User on 05 Jul 2020 23:32:08

RE: Add checking on BLANK for Cadr visual

This should be a standard
functionality.. having to create adhoc measures isn't optimal.. impacts UX

's profile image Profile Picture

Power BI User on 05 Jul 2020 23:31:01

RE: Add checking on BLANK for Cadr visual

please fix asap

's profile image Profile Picture

Yolanda on 05 Jul 2020 23:30:02

RE: Add checking on BLANK for Cadr visual

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

Darren Power BI User on 05 Jul 2020 23:20:52

RE: Add checking on BLANK for Cadr visual

This is urgently needed. Replacing 0 in as default in Tabular measures distorts averages etc. The overhead required to cater for removal of the blank in a particular report is basically to recreate every single measure again, which is crazy.

's profile image Profile Picture

Power BI User on 05 Jul 2020 23:17:31

RE: Add checking on BLANK for Cadr visual

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

Power BI Ideas Admin on 05 Jul 2020 23:14:41

RE: Add checking on BLANK for Cadr visual

I should not have to do this check at the DAX layer, it should be done in the presentation layer. Why make users do stupid DAX tricks, I would prefer a check box just like Excel pivot tables.

's profile image Profile Picture

Suhaib Alnoursi on 05 Jul 2020 23:12:08

RE: Add checking on BLANK for Cadr visual

a lot of basic features are missing in power BI

's profile image Profile Picture

Suhaib Alnoursi on 05 Jul 2020 23:12:08

RE: Add checking on BLANK for Cadr visual

I need to use another word in different language rather than English , we don't have such word

's profile image Profile Picture

Cian Reynolds on 05 Jul 2020 23:10:22

RE: Add checking on BLANK for Cadr visual

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

's profile image Profile Picture

Eric McGowan on 05 Jul 2020 23:06:08

RE: Add checking on BLANK for Cadr visual

This should be a quick easy fix.... please add this functionality

Merged Idea (3)