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'm trying to get that table to not show anything until it is being filtered by either the DESCR slicer or the Map being clicked on, because otherwise it's 11k+ entries. I feel like I must be missing something...
Solved! Go to Solution.
hi @dpiechowski
You could just adjust the formula as below:
m.Hide? =
IF (
CALCULATE ( ISFILTERED ( INVENTORY_BIN[DESCR] ), ALLSELECTED ( INVENTORY_BIN ) ),
1,
IF (
CALCULATE ( ISFILTERED ( BIN_LIST[Zone/Tower] ), ALLSELECTED ( BIN_LIST ) ),
1,
0
)
)
Then it will work.
Regards,
Lin
hi @dpiechowski
You could just adjust the formula as below:
m.Hide? =
IF (
CALCULATE ( ISFILTERED ( INVENTORY_BIN[DESCR] ), ALLSELECTED ( INVENTORY_BIN ) ),
1,
IF (
CALCULATE ( ISFILTERED ( BIN_LIST[Zone/Tower] ), ALLSELECTED ( BIN_LIST ) ),
1,
0
)
)
Then it will work.
Regards,
Lin
This works beautifully. Thanks
@dpiechowski , see if you can use it using the bookmark
https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive
I think I figured it out.
It seems like if the ISFILTERED measure is checking any of the columns that are in the table it doesn't work.
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 |
---|---|
100 | |
97 | |
85 | |
70 | |
67 |
User | Count |
---|---|
116 | |
109 | |
94 | |
79 | |
72 |