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.
Hello,
I have a slicer on Color, is there a way to only show those colors, where values are in rest of teh columns, if any of the column does not have value I do not want to show in the slicer.
Color ------- Col 2 ------ Col2 -------- Col3
Red ------- X ------- X ------- X
Blue ------- ------- X ------- X
White ------- X ------- X ------- X
Green ------- X ------- X ------- X
Brown ------- X ------- X -------
Pink ------- ------- X ------- X
I only want Red, White, and Green to show in the slicer, becasue those are the only 3 colors, we have values in the other 3 columns.
Thanks
Solved! Go to Solution.
For whatever reason, slicers do not support visual level filters. You could use page or report filters to filter these out, or you could simply do something like this:
Column = SWITCH(TRUE(), ISBLANK([Col1]) || ISBLANK([Col2]) || ISBLANK([Col3]), BLANK(), 1 )
And then:
SlicerTable = DISTINCT(SELECTCOLUMNS(FILTER('Table8 2',[Column]=1),"Color",[Color]))
Relate this table to your other table in the obvious way. Use it as your slicer instead.
For whatever reason, slicers do not support visual level filters. You could use page or report filters to filter these out, or you could simply do something like this:
Column = SWITCH(TRUE(), ISBLANK([Col1]) || ISBLANK([Col2]) || ISBLANK([Col3]), BLANK(), 1 )
And then:
SlicerTable = DISTINCT(SELECTCOLUMNS(FILTER('Table8 2',[Column]=1),"Color",[Color]))
Relate this table to your other table in the obvious way. Use it as your slicer instead.
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 |
---|---|
117 | |
104 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |