Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I have a group of data in a table "ItemGroups" with the following format:
I want to use a slicer to select a single item. Currently, this returns all the groups in which that item number is a part of. What I am looking for is the table visualization to return all item numbers that share the group. In the example below, I want the table visualization to return all item numbers that contain group B (this will include the selection in the slicer), group H, group N, etc.
Can this be done as a visual filter using a measure?
Solved! Go to Solution.
HI @Anonymous,
For original slicer, it is impossible to achieve your requirement.
You need to create new table as source of slicer and coding measure to filter records.
Steps:
1. Create table with 'item number' and 'groups' from original table as select table.(these tables not have relationship)
Selector =
SELECTCOLUMNS ( Table, "Item Number", [Item Number], "Groups", [Groups] )
2. Use Item Number(from selector table) as source column of slicer.
3. Write measure to get selected group list and check original table row content to return tag.
Tag = VAR selectList = CALCULATETABLE ( VALUE ( Selector[Groups] ), ALLSELECTED ( Selector ) ) RETURN IF ( SELECTEDVALUE ( Table[Groups] ) IN selectList, "Y", "N" )
4. Drag above measure to visual level filter with advanced filter mode to filter records who not equal to "Y" tag.
Regards,
Xiaoxin Sheng
HI @Anonymous,
For original slicer, it is impossible to achieve your requirement.
You need to create new table as source of slicer and coding measure to filter records.
Steps:
1. Create table with 'item number' and 'groups' from original table as select table.(these tables not have relationship)
Selector =
SELECTCOLUMNS ( Table, "Item Number", [Item Number], "Groups", [Groups] )
2. Use Item Number(from selector table) as source column of slicer.
3. Write measure to get selected group list and check original table row content to return tag.
Tag = VAR selectList = CALCULATETABLE ( VALUE ( Selector[Groups] ), ALLSELECTED ( Selector ) ) RETURN IF ( SELECTEDVALUE ( Table[Groups] ) IN selectList, "Y", "N" )
4. Drag above measure to visual level filter with advanced filter mode to filter records who not equal to "Y" tag.
Regards,
Xiaoxin Sheng
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
90 | |
89 | |
79 | |
70 | |
68 |
User | Count |
---|---|
226 | |
129 | |
119 | |
84 | |
77 |