Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |