Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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.
Solved! Go to Solution.
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.
filtered
No filtered
7. Ready & Celebrate 😃
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.
filtered
No filtered
7. Ready & Celebrate 😃
Work great. Thanks for help.
Hi @silserwis,
Please mark the workground as answer, so more people will benefit from it.
Best Regards,
Angelia
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
User | Count |
---|---|
120 | |
65 | |
62 | |
56 | |
50 |
User | Count |
---|---|
177 | |
85 | |
70 | |
63 | |
55 |