cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
patkang
Helper I
Helper I

Table visual not correct for top row

Dear Community

 

To track activity on an online platform I have a list of userIDs that are not active. This list is connected to the UserLookup table that contains more detailed information about the users such as email adress, name and so on. 

In matrix visual I added the User Id from the "Inactive User" Table and added the names and email adresses in the rows.

The visual works fine but for the top row, it shows me the first (or last if i select "last") of all users names by alphabet even though this person's userID is not in the "Inactive User" Table. 

Am I missing something or why does this visual behave in that way?

 

The Inactive User Table contains User IDs that are in the User Summary Table but not in the Learner Activity Table. 

The visual has User ID from Inactive user Table in Rows and Names & Email adress from the User Summary.

 

Any support I can get is much appreciated! Thank you!Slide1.JPGSlide2.JPG

1 ACCEPTED SOLUTION
Icey
Community Support
Community Support

Hi @patkang ,

 


 

The Inactive User Table contains User IDs that are in the User Summary Table but not in the Learner Activity Table. 

The visual has User ID from Inactive user Table in Rows and Names & Email adress from the User Summary.

 


This may casued by that there is one or more records of "IDs" in User Summary table, but not in Inactive User Table. Something like below. Please check.

 

blank value.JPG

 

 

Best regards

Icey

 

If this post helps, then consider Accepting it as the solution to help other members find it faster.

View solution in original post

6 REPLIES 6
patkang
Helper I
Helper I

@Rigensis 

Thanks a lot for your answer

 

The thing is, I use the User Summary table kind of like a Lookup table but there is only 1:1 relationship since all users only exist once in the model. I tried doing a one fdirection filter but apparently it does not work in a 1:1 relationship.

I tried filtering the visual manually for blanks but that option does not exist. When I call out for the filtering options, it does not recognize a blank. 

I would have to filter manually by the name of the person that appears at the top. 

 

Icey
Community Support
Community Support

Hi @patkang ,

 


 

The Inactive User Table contains User IDs that are in the User Summary Table but not in the Learner Activity Table. 

The visual has User ID from Inactive user Table in Rows and Names & Email adress from the User Summary.

 


This may casued by that there is one or more records of "IDs" in User Summary table, but not in Inactive User Table. Something like below. Please check.

 

blank value.JPG

 

 

Best regards

Icey

 

If this post helps, then consider Accepting it as the solution to help other members find it faster.

View solution in original post

@Icey thanks a lot for the hint. Will fix the issue as described, perhaps changing the relationship or keep them separate. 

 

Kind regards

PatKang

Icey
Community Support
Community Support

Hi @patkang ,

 

Please check if the suggestions @Rigensis provided work.

 

If they work, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

 

If not, please share us a dummy .pbix file, without sensitive information, for test. It is suggested to upload your file to OneDrive for Business and then paste the link here.

 

 

 

Best regards

Icey

 

If this post helps, then consider Accepting it as the solution to help other members find it faster.

 

Rigensis
Helper I
Helper I

@patkang Another option that you could try is to change table relationship between Inactive Users and UserSummary to

 

Inactive User 1 -->-- * UserSummary

One to many relationship with one way single cross filter direction. 

Even if the table do match 1 to 1, you only need Inactive User table to filter the UserSummary table, and not the other way around.

Rigensis
Helper I
Helper I

@patkang From your explanation I gather that you don't even want to see the entry that is in the top row.

So would it be enough if you just filter the User ID column in the filter pane to not show (Blank)?

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

March Update

Check it Out!

Click here to read more about the March 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.