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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
jpBlue
Frequent Visitor

My Table refresh when i choose a Row

Hello everyone!  im a new learner here.

 

As title says, my table refreshes whenever i choose a value in a row.

 

Below is a sample scenario:

I have a dataset coming from  two excel files.

File 1

UserCodeNameCountry
AMarkPHP
BJohnTH
CKimCN
EShaunUS
FTimCN
GDiegoUK

File 2

CodeGameAward
ABasketballGold
BBadmintonSilver
CBasketballGold
EBadmintonBronze
FBadmintonBronze
GBasketballGold

 

The Code column is the primary key that connects two table.

I created three Table visualization:

Table 1 shows Country

Table 2 shows Players on the selected country in Table 1

Table 3 shows Awards

 

Now if i click Table 1 Country, it correctly shows all the Players in Table 2. The problem comes if i select a row in Table 2.

Using the filtered players in Table 2, i want to filter their awards if they won gold,silver or bronze. But whenever I choose a player in Table 2, it refreshes the whole table.

Table 3 correctly show the value but Table 2 has all the players again even I selected a specific value. Table 1 now shows the country of that player selected before it was refresh.

I saw a bit similar case here in the community and it suggested that whenever choosing a row, instead of clicking, use the CTRL + click to select one or multiple value.

Is this the normal behavior or my relationship on two tables is incorrect. Im using Both in cross filter direction.

 

Hopefully someone could help me out 😟

 

Thank you!

1 REPLY 1
foodd
Super User
Super User

Please provide your work-in-progress Power BI Desktop file (with sensitive information removed) that covers your issue or question completely in a usable format (not as a screenshot).

https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

This allows members of the Forum to assess the state of the model, report layer, relationships, and any DAX applied.

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.