topic Re: How to show blank values when “Select all” is deselected in a disconnected slicer in DAX Commands and Tips

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

AnkittM08 — Thu, 06 Nov 2025 09:36:25 GMT

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!

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

Praful_Potphode — Thu, 06 Nov 2025 06:44:41 GMT

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

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

vivien57 — Thu, 06 Nov 2025 06:32:05 GMT

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

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

v-tejrama — Sun, 09 Nov 2025 05:57:55 GMT

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!

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

AnkittM08 — Sun, 09 Nov 2025 09:46:17 GMT

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.

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

vivien57 — Mon, 10 Nov 2025 06:43:37 GMT

Try this DAX code then:

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

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

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

AnkittM08 — Mon, 10 Nov 2025 07:29:19 GMT

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?

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

vivien57 — Mon, 10 Nov 2025 07:35:52 GMT

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

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

Praful_Potphode — Mon, 10 Nov 2025 08:18:33 GMT

AnkittM08 did you try above 2 measures?

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

AnkittM08 — Mon, 10 Nov 2025 08:59:45 GMT

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.

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

v-tejrama — Wed, 12 Nov 2025 09:48:08 GMT

Hi AnkittM08 ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

Thank you.

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

v-tejrama — Thu, 20 Nov 2025 08:49:16 GMT

Hi AnkittM08 ,

I wanted to check if you had the opportunity to review the information provided by vivien57.
Please feel free to contact us if you have any further questions.

Thank you.

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

AnkittM08 — Wed, 03 Dec 2025 07:20:11 GMT

Hi everyone,

Thank you all for your valuable suggestions. I tried each of them, but some options were still causing issues. I then explored another visual called “Text Slicer Button”, and it perfectly meets all my requirements.

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

AnkittM08 — Wed, 03 Dec 2025 07:25:20 GMT

Hi everyone,

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

v-tejrama — Wed, 03 Dec 2025 08:00:44 GMT

Hello again AnkittM08 ,

Thank you for sharing your insights. Your input is very helpful and may benefit others who encounter this topic.

Thank you.