Forum Discussion

jerryr125's avatar
jerryr125
Icon for Helper IV rankHelper IV
2 years ago
Solved

Power BI Table visualization - issue with filtering with data from two different tables

Hi - I have a question about the table visualization. Data Model   Data Model Table1 Location Acounter 100 10 200 15 300 20   Data Model Table2 Location Bcounter Flag ...
Show and Tell
  • lbendlin's avatar
    lbendlin
    2 years ago

    Create a proper dimension table for Location. Add all four locations.

     

    Create your data model.

     

     

     

      Then use that dimension column as the first column in the visual, and add the A and B values. Then apply the B filter.

     

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

Create a proper dimension table for Location. Add all four locations.

 

Create your data model.

 

 

 

  Then use that dimension column as the first column in the visual, and add the A and B values. Then apply the B filter.