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"
Yes, I agree this is a much needed functionality! I had to exclude blanks using the filter option as a workaround, but this tends to skew my results.
RE: Field Groups for Blank Values Rolled in to "Other"
Agreed, I could use this as well.
RE: Field Groups for Blank Values Rolled in to "Other"
This is a critical missing feature for grouping. Not being able to decide what is to be done with empty values can mess up an entire report whenever blanks appear, since there is no way to account for the space it will occupy in a visual and consumers can have a hard time figuring out what the blank means (even an "Unspecified" label would be better).
I know blank values can be managed within the data model to prevent the problem, but when working with Direct Query a workaround might be impossible or too complex.
RE: Field Groups for Blank Values Rolled in to "Other"
Still need this...