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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.