Skip to main content

Power BI

Needs Votes

Add checking on BLANK for Cadr visual

Vote (196) 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 (19)
's profile image Profile Picture

e334019f 7ff3-47ed-86b4-a724f24b41fe on 06 Jul 2020 00:13:51

RE: Add checking on BLANK for Cadr visual

this needs to be fixed asap - such a obvious fix to be made to card visual rather than duplication of measures in model.

's profile image Profile Picture

7c5a602c 8d4d-49d7-b786-954134fac9b3 on 06 Jul 2020 00:10:44

RE: Add checking on BLANK for Cadr visual

They need to combine this with this idea
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/10110324-count-should-return-0-instead-of-blank

And

providing option of alternative text when there is no data to show in a chart

's profile image Profile Picture

411cd5a7 9fb2-4216-8861-e55f4029ab56 on 06 Jul 2020 00:09:54

RE: Add checking on BLANK for Cadr visual

Someone needs to correct this please.

's profile image Profile Picture

c6025f1c d5fd-415e-8d49-9f4505afcc50 on 06 Jul 2020 00:09:27

RE: Add checking on BLANK for Cadr visual

Please fix so that counts of 0 show as "0"
0 is data. (blank) is not!

's profile image Profile Picture

5624e5aa 3d20-4787-926e-b031a4b7a23d on 06 Jul 2020 00:09:21

RE: Add checking on BLANK for Cadr visual

Please, fix this.

's profile image Profile Picture

d1def052 fd4d-44c0-b243-c69388c8d435 on 06 Jul 2020 00:08:55

RE: Add checking on BLANK for Cadr visual

I am in this boat too, please, fix it.

's profile image Profile Picture

714a0553 0a10-43bd-8697-76a607e1f63f on 06 Jul 2020 00:08:31

RE: Add checking on BLANK for Cadr visual

Microsoft please FIX this. It will save a lot of time and effort. Cannot create a measure for every card on every report.

's profile image Profile Picture

ea0fc290 655e-466a-bb5a-d9260f52c71a on 06 Jul 2020 00:04:07

RE: Add checking on BLANK for Cadr visual

This feature will be great and will save me a lot of time having to create measures for simply showing the count of records. The card i'm using counts the number of rows affected, if i introduce a slicer and no rows are returned for certain combinations it shows (Blank).

's profile image Profile Picture

70bbc250 83f8-4169-b66a-cea558368f68 on 06 Jul 2020 00:01:02

RE: Add checking on BLANK for Cadr visual

Please add this to the next update, this should be OOB functionality.

's profile image Profile Picture

d8441e6a bfd7-4930-9923-2612f87d0af3 on 05 Jul 2020 23:59:52

RE: Add checking on BLANK for Cadr visual

This seems to be such a basic idea I'm baffled as to why it hasn't been developed