Clean summary table & chart when nothing is selected in the slicer

[Anonymous]

Hi,

I have created a slicer and a data summary and a line chart will be modified based on the selection.

Is there a way to make the summary table to be blank when the slicer is not selected?

I've tried to apply the measure that I created <Slicer Selected> under visual level filters; however, it's still not working.

Thanks in advance for the assistance.

[v-ljerr-msft · Accepted solution]

Hi @Anonymous,

I've tried to apply the measure that I created <Slicer Selected> under visual level filters; however, it's still not working.

---

What formula are you using to create the <Slicer Selected> measure?

Base on my test, I can use the following formula to create the <Slicer Selected> measure, then use it as visual level filters(<Slicer Selected> is "Yes") to clean the table visual in your scenario. 

Slicer Selected =
IF (
    CALCULATE (
        ISFILTERED ( 'TableName'[SlicerColumn] ),
        ALLSELECTED ( 'TableName'[SlicerColumn] )
    ),
    "Yes",
    "No"
)

Regards

[Anonymous]

Thanks so much. After modifying my formula to match yours, it works for me now.

I only have the ISFILTERED in my original formula and I guess that is where I made the mistakes.