Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Butterfly
New Member

How to group (Blank) relations in the Power Bi Desktop App

I have a pie chart that shows groups of a certain category (in my case groups of status).

Butterfly_5-1666104871115.png

As you can see, there is a option named "(Blank)". I want to assign these blanks to one of my groups instead of them showing seperately, as can be seen here for example (see the answer of @v-huizhn-msft in Why there is a (BLANK) option for my new grouping in Power bi). However, in my case, Power Bi doesn't list Blank ones in the ungrouped values - in a nutshell: I can't assign the Blanks to a group. 

 

My theory is, that the issue might lie within the Blanks not being empty fields but nonexistent relations in my case. I don't have  a column "Status" in the same table, but in a related table and not every dataset has a related one in the other table (where the Status field is). 

 

Is there a way to group datasets where the relationship is "blank"? Have I missed to adapt a certain property?

And if it is not possible: do you have an idea what a clean way to solve this issue would be?

 

Even after extended research I couldn't quite figure it out and would be really thankful for some help :). 

 

Here is my case in more detail, if you need more information to grasp the issue: 

The data model looks something like this (simplified for this question): 

Butterfly_1-1666162536067.png

The relationships active in both directions: 

Butterfly_6-1666105121645.png

For my pie chart I counted the Elements of the right table by Status groups: 

Butterfly_3-1666104510177.png

I created and edited these groups like this (see "New group" and "Edit group")

Butterfly_1-1666107852576.png

Butterfly_4-1666104607627.png

This is the resulting pie chart: 

Butterfly_5-1666104871115.png

As you can see there is a new Category named "(Blank)" that I want to assign to group 2. 

But as you can see in the Edit-view of the groups, there is no blank option to be assigned to one of the groups.

Butterfly_4-1666104607627.png

5 REPLIES 5
nandostate17
New Member

Hello, I found a solution, you just create a new group from the group you already created and it will appear the blank as one of the variables to group 😄
s--turn
Helper I
Helper I

I would also like to know the answer to this.  In my case, I have two values, "Member" and "Non Member", but I also have blanks resulting from transactions where the person does not have a full record telling us whether they are a member or not.  For these blanks, I would like to group them with the non-members.  If this is not possible, does anyone know if it has been put forward as an idea to be upvoted?

pinar1
Frequent Visitor

Is there a solution for this? I also do not see the blank values when i try to group them. But then they emerge as a seperate group in the report. 

v-rongtiep-msft
Community Support
Community Support

Hi @Butterfly ,

Go to Filters pane and select "is not blank" in the field of the group (Filters on this visual).

 

If I have misunderstood your meaning, please provide more details with your desired output and pbix file without privacy information.

 

Best Regards

Community Support Team _ Polly

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hello @v-rongtiep-msft

thank you for your time and effort! 

However, I do not want to ignore the blank datasets, like you would do by filtering for "is not blank", since that would distort the graphs statement, but rather, as I said in my question, include the blank ones in one of the groups, so that they are not listed seperately. But when I edit the groups, there is no "blank" that I can assign to the group of my desire. 

Do you have any ideas, on why that is and how to best cope with this issue?

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Power BI Header Change

Power BI Header Update

Read about the exciting updates for the Power BI forum.