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!

[v-tejrama]

Hi @AnkittM08 ,

Thank you @vivien57 and @Praful_Potphode  for the response provided!

Has your issue been resolved? If the response provided by the community member addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.

Thank you for your understanding!

[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

[AnkittM08]

Hi Vivien,

I have already applied this approach, but it isn’t working as expected. It only works for one condition — when a selection is made, the card visual shows correctly. However, when I deselect (or select all), the card visual still appears blank for both selection and deselection cases.

[vivien57]

Try this DAX code then:

IsNothingSelected = 
IF(
    ISFILTERED(Toto[Category]) && COUNTROWS(VALUES(Toto[Category])) = 0,
    TRUE(),
    FALSE()
)

or

RevenueFiltered = 
IF(
    NOT(ISFILTERED(Toto[Category])),
    BLANK(),
    [TotalRevenue]
)

[AnkittM08]

I tried using the following measure in my matrix visual:

Is Nothing Selected = INT(ISFILTERED(ItemTypeTable[ItemType]))

I applied a visual-level filter where the value is set to “1”. It currently works in such a way that when all items are selected (meaning all tiles are highlighted), no data appears in the matrix — the same happens when nothing is selected in the slicer.

However, I want the opposite behavior:

1. When all items are selected, the matrix should show data.

2. When nothing is selected, the matrix should show blank.

One limitation of this measure is that it cannot be applied to any card visual. Could you please help modify the measure so it supports this logic and works in both matrix and card visuals if possible?

[vivien57]

Try this :

RevenueFiltered = 
VAR SelectedItems = VALUES(ItemTypeTable[ItemType])
VAR TotalItems = COUNTROWS(ALL(ItemTypeTable[ItemType]))
VAR SelectedCount = COUNTROWS(SelectedItems)
VAR IsNothingSelected = SelectedCount = 0
VAR IsAllSelected = SelectedCount = TotalItems

RETURN
    IF(
        IsNothingSelected,
        BLANK(),
        [TotalRevenue]  -- existing measure
    )

• VALUES(...) retrieves the selected items.
• ALL(...) retrieves all possible items.
• If SelectedCount = 0 → nothing is selected → BLANK() is displayed.
• If SelectedCount = TotalItems → everything is selected → data is displayed normally.

Use this measure in your card or matrix. Do not put a visual filter on Is Nothing Selected, as this logic is already built into the measure.

Please feel free to give a kudo or validate as an answer 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

[AnkittM08]

Hi @Praful_Potphode
Thank you for your suggestion to help me achieve my requirement; however, I’ve already tried this approach, and it didn’t work as expected.

[Praful_Potphode]

@AnkittM08  did you try above 2 measures?