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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
silserwis
New Member

filtered and not filtered values on one page

I want to create report that show filtered values on one table view and all other values from the same column that are not filtered on second table view. For example i have this table:

name    group

name1  grp1

name2  grp1

name3  grp2

name4  grp3

 

I have one slicer for group and two table views for name ( only name column )

When slicer is not selected then table1 show all names, table2 is empty.

When I click "grp1" on slicer then table1 show ("name1" and "name2"), table2 show ("name3" and "name4")

 

How to achieve that results.

 

 

1 ACCEPTED SOLUTION
Vvelarde
Community Champion
Community Champion

@silserwis

 

Hi, one way to show the 2 tables views is:

 

1. Create a new table with the groups:

 

Modeling- New Table

 

GroupTable = DISTINCT(Table1[Group])

 

2. Insert a slicer using the Group column from GroupTable

 

3. Insert 2 tables with the Names

 

4. Create a measure

 

Measure =
IF (
    COUNTROWS (
        INTERSECT ( VALUES ( GroupTable[Group] ), VALUES ( Table1[Group] ) )
    )
        > 0,
    1,
    0
)

5. Use this measure in Visual Level Filter in the 2 table visuals

 

6. Filter the filtered view to 1 and the not filtered to 0.

 

filteredfiltered

 

No filteredNo filtered

7. Ready & Celebrate 😃

 

filtered.gif

 

 

 




Lima - Peru

View solution in original post

4 REPLIES 4
Vvelarde
Community Champion
Community Champion

@silserwis

 

Hi, one way to show the 2 tables views is:

 

1. Create a new table with the groups:

 

Modeling- New Table

 

GroupTable = DISTINCT(Table1[Group])

 

2. Insert a slicer using the Group column from GroupTable

 

3. Insert 2 tables with the Names

 

4. Create a measure

 

Measure =
IF (
    COUNTROWS (
        INTERSECT ( VALUES ( GroupTable[Group] ), VALUES ( Table1[Group] ) )
    )
        > 0,
    1,
    0
)

5. Use this measure in Visual Level Filter in the 2 table visuals

 

6. Filter the filtered view to 1 and the not filtered to 0.

 

filteredfiltered

 

No filteredNo filtered

7. Ready & Celebrate 😃

 

filtered.gif

 

 

 




Lima - Peru

Work great. Thanks for help.

Hi @silserwis,

Please mark the workground as answer, so more people will benefit from it.

Best Regards,
Angelia

v-huizhn-msft
Employee
Employee

Hi @silserwis,

After test, we are unable to achieve what you want. The slicer is used to filter the rows, filter affect one report or not. If we select one value in slicer, it returns the corresponding values in report, otherwise, it shows all the value. There is no way to split one table to two tables automatically based on the slicer. Thanks for understanding.

Best Regards,
Angelia

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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