Filter data from same data model in power bi

[itstechno]

Hi all,

I have used table visual to show all below mentioned data 
Now if i click on row2 where station is EOLT2. I want to display all the data in another table visual where station have EOLT2.
I have this single model

Error	TestNumber	Retest	MotorType	Station	Date	Storke	ID
OK	1	1	Manual	EOLT1	1/1/2024	ESSV_1	a1
a	1	1	PWM	EOLT2	1/2/2024	ESSV_2	a2
b	1	0	Contact	EOLT3	1/3/2024	ESSV_3	a3
c	1	0	Manual	EOLT4	1/4/2024	ESSV_4	a5
d	1	0	PWM	EOLT5	1/5/2024	ESSV_5	a6
OK	1	1	Contact	EOLT1	1/6/2024	ESSV_6	a1
OK	2	1	Manual	EOLT1	1/7/2024	ESSV_7	a3
ac	2	0	PWM	EOLT3	1/8/2024	ESSV_8	a4
a	2	1	Contact	EOLT2	1/9/2024	ESSV_9	a5
b	2	1	Contact	EOLT3	1/10/2024	ESSV_1	a6
b	2	1	PWM	EOLT4	1/11/2024	ESSV_2	a7
r	2	0	Contact	EOLT2	1/12/2024	ESSV_3	a3
OK	3	0	PWM	EOLT3	1/13/2024	ESSV_4	a6
a	3	0	PWM	EOLT4	1/14/2024	ESSV_5	a7
a	3	0	Contact	EOLT5	1/15/2024	ESSV_6	a12
c	3	1	Contact	EOLT1	1/16/2024	ESSV_7	a34
OK	1	1	MotorType	EOLT3	1/17/2024	ESSV_8	a12
OK	2	1	PWM	EOLT5	1/18/2024	ESSV_9	a13

Looking for help and support

[Ashish_Mathur]

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.

[itstechno]

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

[Jai-Rathinavel]

@itstechno Select your relationship and set your cross filter direction to both like below.

Did I answer your question? Please mark this post as a solution.

Thanks,

Jai

[VahidDM]

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