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)
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?
RE: Field Groups for Blank Values Rolled in to "Other"
sill not fixed, so important!
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.
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
RE: Field Groups for Blank Values Rolled in to "Other"
This is needed asap.
Without this fix, grouping is effectively useless for business application.
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.
RE: Field Groups for Blank Values Rolled in to "Other"
Needed so much
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.
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
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.