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 have a scenario where I want to list a table of stores filtered by one level higher hierarchy than the store selected.
So normal, slicer interaction, the user selects the store from slicer and the table is filtered to that store:
but I want the table to display all stores in the selected store's area, not just the single store. Like this:
How do I accomplish this?
Solved! Go to Solution.
You could create a disconnected copy of the stores and areas for use in the slicer, e.g.
Table for slicer = SUMMARIZE( 'Table', 'Table'[Store], 'Table'[Area])
Use the store column from this new table on the slicer, then create a measure like
Store is visible =
IF (
SELECTEDVALUE ( 'Table'[Store] )
IN CALCULATETABLE (
VALUES ( 'Table'[Store] ),
TREATAS ( VALUES ( 'Table for slicer'[Area] ), 'Table'[Area] )
),
1
)
and add that as a visual level filter to your table, set to show only when the value is 1.
That worked perfectly! Thanks
You could create a disconnected copy of the stores and areas for use in the slicer, e.g.
Table for slicer = SUMMARIZE( 'Table', 'Table'[Store], 'Table'[Area])
Use the store column from this new table on the slicer, then create a measure like
Store is visible =
IF (
SELECTEDVALUE ( 'Table'[Store] )
IN CALCULATETABLE (
VALUES ( 'Table'[Store] ),
TREATAS ( VALUES ( 'Table for slicer'[Area] ), 'Table'[Area] )
),
1
)
and add that as a visual level filter to your table, set to show only when the value is 1.
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 |
---|---|
107 | |
100 | |
80 | |
63 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |