Filter data from same data model in power bi

Hi itstechno 

Yes, you can achieve this by setting up visual interactions in Power BI. Here's how:

1. Create Two Table Visuals:

   • Table 1: Add your data fields to display all records.
   • Table 2: Add the fields you want to display when filtered.

2. Enable Cross-Filtering:

   • By default, selecting a row in one table filters other visuals. Ensure this is enabled.
   • If not, go to the "Format" tab on the ribbon and select "Edit Interactions."

3. Adjust Visual Interactions:

   • With Table 1 selected, check the icons above Table 2.
   • Make sure the filter icon (funnel) is active for Table 2. This means Table 1 will filter Table 2 based on your selection.

4. Set Up the Filtering Field:

   • Ensure the "Station" column is included in both tables or properly related in your data model.
   • This allows Table 2 to filter data based on the "Station" selected in Table 1.

5. Test the Interaction:

   • Click on a row in Table 1 where Station is EOLT2.
   • Table 2 should now display all records where Station = EOLT2.

6. Optional – Disable Unwanted Interactions:

   • If you don't want Table 2 to affect Table 1, ensure the filter icon is turned off when Table 2 is selected.

Note:

• Data Model: Since you have a single data model, ensure there are no conflicting relationships.
• Selection Mode: Ensure that the selection in Table 1 is set to single-select if you want to filter by one station at a time.

By configuring the visual interactions, you can display all data in the first table and have the second table show data filtered by the station selected in the first table.

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

Appreciate your Kudos!! 

LinkedIn|Twitter|Blog |YouTube 

Hi VahidDM , I am still no able to filter the data in 2nd table visual as per selection in first table visual
Here is my data model

Cross filtering is enabled 

But I am getting single row only in 2nd table visual when I select row in above table

Hi,

What happens when you click on EOLT2 (not the row but just the text EOLT2)?  Also, consider using a slicer and select EOLT2 there.