Power BI

New

Field Groups for Blank Values Rolled in to "Other"

Vote (76)

PMI PowerBI on 15 Nov 2016 00:55:16

Blank values do not currently roll into the "Other" ungrouped values when creating group filters.

The Blanks are still to be displayed as part of the dataset but it would be ideal to consider these as ungrouped so they could be named in a group.

Comments (14)

Comments (14)

2363a997 8300-4d82-9145-339484daebd1 on 06 Jul 2020 00:13:44

RE: Field Groups for Blank Values Rolled in to "Other"

There's a simple solution. Just create a new column and assign a new value to your blank row.

Revised column = if(isblank(current column), "Blank", current column)

Then you can use the new column. Am I missing something here?

bbc2fc4d 93e6-489c-a761-0067d382f946 on 06 Jul 2020 00:13:24

RE: Field Groups for Blank Values Rolled in to "Other"

sill not fixed, so important!

deedf500 144e-4b1c-a17e-581eb1259e4e on 06 Jul 2020 00:01:59

RE: Field Groups for Blank Values Rolled in to "Other"

This is very necessary to capture unmatched values in the model. I don't want to exclude those values. I want to be able to report those blanks (unmatched) into a catchall category I can define like unknown/other/missing etc.

caccc511 fefa-43e3-abf7-08cdef1e4bff on 05 Jul 2020 23:56:14

RE: Field Groups for Blank Values Rolled in to "Other"

I actually need to group all the blank values into 1 group with a name in addition to "Other", so yes the ability to group blank values is much needed. Please add this feature. Thank you

accfbf45 c99a-44bd-a0b4-3ef23e227e91 on 05 Jul 2020 23:52:29

RE: Field Groups for Blank Values Rolled in to "Other"

This is needed asap.

Without this fix, grouping is effectively useless for business application.

8c98c041 3322-4a9a-b5a2-1ce8b90de088 on 05 Jul 2020 23:51:04

RE: Field Groups for Blank Values Rolled in to "Other"

Just finished a brief call with Support on this issue. I was told it could be at least 2 months to have this issue resolved due to other feature priorities.

b99b17e6 eb69-4ab4-a7c4-8f2a46033e1b on 05 Jul 2020 23:42:29

RE: Field Groups for Blank Values Rolled in to "Other"

Needed so much

333116d9 d484-4553-977d-088e8055f601 on 05 Jul 2020 23:39:47

RE: Field Groups for Blank Values Rolled in to "Other"

This appears to be a bug rather than an improvement request as the suggestion by New below appears to be a workaround (that's just saved me a load of work - thanks!) as blanks should appear as an option without needing to create a group of a group.

e6d04855 1f3e-4dfe-9c5b-ea42892aab8d on 05 Jul 2020 23:36:33

RE: Field Groups for Blank Values Rolled in to "Other"

you could do group on the group to includes blank to either of the previous group you have set up

693b8edc 4b87-4369-9572-177ea590525c on 05 Jul 2020 23:34:22

RE: Field Groups for Blank Values Rolled in to "Other"

Has a solution to this problem been found? We need this for our reports also please.