How to show blank values when “Select all” is deselected in a disconnected slicer

[AnkittM08]

Hi Community,

I’ve created a disconnected table to use as a slicer for filtering total revenue displayed in a card visual. The slicer works correctly when users select specific items (e.g., Category 3, Category 4, Category 5, etc.).

However, I’ve noticed an issue with Power BI’s default behavior: when all options are selected, and the user clicks “Select all”, it actually deselects everything — but the card visual still shows total revenue instead of going blank.

In this case, I want the card visual (and report visuals) to show blank values when the slicer is in a fully deselected state (after “Select all” is clicked). I’ve tried several approaches using DAX and conditional logic, but none seem to detect the “fully deselected” state correctly.

Has anyone found an effective way to handle this behavior in disconnected slicers so that visuals return blank when nothing is selected?

Thanks in advance for any help or ideas!

[vivien57]

Hello @AnkittM08 ,

You need to create a DAX measure that detects if nothing is selected in the slicer and then use this measure in the visual card.

Let's take the example of a disconnected table called "toto" and column "category".

SelectedCategoryCount = 
IF(
    ISFILTERED(Toto[Category]),
    COUNTROWS(VALUES(Toto[Category])),
    0
)

Then, you can create a conditional measure for the card :

RevenueFiltered = 
IF(
    [SelectedCategoryCount] = 0,
    BLANK(),
    [TotalRevenue]  -- your existing measure
)

Please feel free to give me a kudo and accept my answer as the solution if it helped you.

have a nice day,

vivien

[Praful_Potphode]

Hi @AnkittM08 ,

you can create customer measure like below.

FOrecast Value = IF(
                 ISBLANK(SELECTEDVALUE(FactTable[Forecasted Isoweek]))
                 ,BLANK() //output for select all condition
                 ,SUM(FactTable[Forecasted Value]))

when all values are selected then selected value returns BLANK,we can check for blanks and return the desired output we want.

another measure you can try is combination of FILTERS and distinct which is computaion wise expensive operation for this problem.

FOrecast Value 2 = 
var filtered_Values=COUNTROWS(FILTERS(FactTable[Forecasted Isoweek])) //this will get selected column values in slicer
var distinct_values=CALCULATE(DISTINCTCOUNT(FactTable[Forecasted Isoweek]),ALL(FactTable)) // this will give total values in slicer
RETURN 
IF(
    filtered_Values=distinct_values // all values are selected
    ,BLANK() 
    ,SUM(FactTable[Forecasted Value])
)

Please give kudos or mark it as solution once confirmed.

Thanks and Regards,

Praful