Empty table with a slicer

[Anonymous]

Is it possible to have a an empty table unless a specific slicer item is chosen? In other words, if a slicer item is not chosen, nothing in the table will apear, and then when a specific slicer is chosen only the specified information for that particular slicer shows up? 

Thanks

[chrisu · Accepted solution]

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.

[SumanthBelawadi]

To show a blank table in a Power BI visual when no data is selected through cross-filtering, you can create a measure that returns a blank value when no filters are applied. Here's a step-by-step guide:

1. Create a Measure:

   • Go to the "Modeling" tab and click on "New Measure".

   • Use the following DAX formula to create the measure:

     BlankMeasure = IF(
         ISFILTERED('YourTable'[YourColumn]),
         1,
         BLANK()
     )

     Replace 'YourTable'[YourColumn] with the actual table and column you are using for filtering.

2. Add the Measure to Your Table Visual:

   • Add this measure to your table visual.
   • Set a filter on this measure to show only rows where the measure equals 1.

3. Adjust the Visual:

   • Go to the "Filters" pane.
   • Drag the BlankMeasure to the "Filters on this visual" section.
   • Set the filter condition to "is not blank".

[chrisu · Accepted solution]

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.

[Sean · Accepted solution]

@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!

[AngeCardoza]

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?

[Anonymous]

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.

[ThomasDay]

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