Forum Discussion
Empty table with a slicer
I recently attempted to answer that in this discussion.
Basically you need a separate measure that evaluates whether a slicer item is chosen, then use that as a visual-level filter in the table. Something like:
SlicerCheck = =if(calculate(distinctcount([SlicerColumn]),allselected([SlicerColumn]))=1,"Y","N")
Then user SlicerCheck as a visual level filter for the table and set it to show values when SlicerCheck is Y.
Anonymous Yes you can do this however the table/matrix column names will always show!
I also suggest using a slightly different Measure to address what KumarDarmesh asks in the Post referenced by chrisu
Test Measure = IF ( ISFILTERED(Table[Column]), BLANK(), 50 )
Drag Test Measure to the The Visual Level Filter => select Show items when the value: is blank => hit Apply filter
The 50 is just a random number could be anything you choose!
I recently attempted to answer that in this discussion.
Basically you need a separate measure that evaluates whether a slicer item is chosen, then use that as a visual-level filter in the table. Something like:
SlicerCheck = =if(calculate(distinctcount([SlicerColumn]),allselected([SlicerColumn]))=1,"Y","N")
Then user SlicerCheck as a visual level filter for the table and set it to show values when SlicerCheck is Y.
Anonymous Yes you can do this however the table/matrix column names will always show!
I also suggest using a slightly different Measure to address what KumarDarmesh asks in the Post referenced by chrisu
Test Measure = IF ( ISFILTERED(Table[Column]), BLANK(), 50 )
Drag Test Measure to the The Visual Level Filter => select Show items when the value: is blank => hit Apply filter
The 50 is just a random number could be anything you choose!
Hey Sean, I ended up using Anonymous's suggestion (you referenced this suggestion in a related topic here) since it gets to the issue of making ONE selection. If there are multiple boxes checked, the slicer check is N. These solutions are very clever. Tom
Hi,
Need help on updating the below measure.
I want to display a static message like "Please select ReportDate" when it is blank. how do i update the measure ?
SlicerCheck = IF ( ISFILTERED(TrendTable[ReportDate]), BLANK(), 10 )
Thanks.
Is there a way to make this work by looking at 2 different filters? We have a Search by A or Search by B...Can I make it so that if either is searched, then it would populate the table?
