web
You’re offline. This is a read only version of the page.
close
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