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've two similar questions.
1) If using a slicer panel that is hidden/unhidden via a bookmark, is it possible to have a eg coloured square to denote when users have selected an item(s) from the slicer, when the slicer panel is hidden ?
2) I may use a bookmark to enable users to switch between seeing either table 1 or table 2. If users click on a region in column A in table 1 and that filters table 2 and they then switch to seeing table 2, is it possible to have a eg coloured square to denote that table 1 /2 is being filtered ?
Solved! Go to Solution.
@AndyDD_UK So you should be able to handle both cases by using a shape visual with conditional formatting using a measure like:
Flag Measure =
VAR __CountAll = COUNTROWS(DISTINCT(ALL('Table'[Region])))
VAR __Count = COUNTROWS(DISTINCT('Table'[Region]))
RETURN
IF(__Count = __CountAll,1,0)
There are also the ISFILTERED, ISCROSSFILTERED and similar DAX functions.
@AndyDD_UK So you should be able to handle both cases by using a shape visual with conditional formatting using a measure like:
Flag Measure =
VAR __CountAll = COUNTROWS(DISTINCT(ALL('Table'[Region])))
VAR __Count = COUNTROWS(DISTINCT('Table'[Region]))
RETURN
IF(__Count = __CountAll,1,0)
There are also the ISFILTERED, ISCROSSFILTERED and similar DAX functions.
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |