Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago
Solved

Empty table with a slicer

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 ch...
Need Help
  • chrisu's avatar
    chrisu
    10 years ago

    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's avatar
    Sean
    10 years ago

    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!

chrisu's avatar
chrisu
Responsive Resident
10 years ago

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's avatar
Sean
Community Champion
10 years ago

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!

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    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.

  • AngeCardoza's avatar
    AngeCardoza
    New Member
    3 years ago

    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?