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

Question

Hi,&nbsp;I have created a slicer and a data summary and a line chart will be modified based on the selection.&nbsp;Is there a way to make the summary table to be blank when the slicer is not selected?&nbsp;I've tried to apply the measure that I created &lt;Slicer Selected&gt; under visual level filters; however, it's still not working.&nbsp;Thanks in advance for the assistance.&nbsp;

v-ljerr-msft · Accepted Answer

Hi&nbsp;Anonymous,
I've tried to apply the measure that I created &lt;Slicer Selected&gt; under visual level filters; however, it's still not working.
What formula are you using to create the&nbsp;&lt;Slicer Selected&gt; measure?
Base on my test, I can use the following formula to create the&nbsp;&lt;Slicer Selected&gt; measure, then use it as&nbsp;visual level filters(&lt;Slicer Selected&gt; is "Yes") to clean the table visual in your scenario.&nbsp;:smileyhappy:
Slicer Selected =
IF (
    CALCULATE (
        ISFILTERED ( 'TableName'[SlicerColumn] ),
        ALLSELECTED ( 'TableName'[SlicerColumn] )
    ),
    "Yes",
    "No"
)

Regards

Forum Discussion

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

2 Replies

Related content

Power BI July 2026 Feature Summary

Select all works the same as select nothing

IF with SELECTEDVALUE nothing selected give total

How to show blank when nothing is selected

Field Parameters nothing selected, show blank on a visual