Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
P-Lag
Helper I
Helper I

Filter if nothing is selected in a Slicer - then don't show data on cards

Hi,

In my Power BI report, I have some cards with data. Is it possible to add a filter on cards? Like, if nothing is selected in a Slicer - then don't show data. I know it's possible for other visualizations in BI, by using the below dax. But it doesn't work for cards.

 


IsCategoryFiltered =
CALCULATE (

    IF ( ISFILTERED ( Deliveries[Equipment ID] ) || ISFILTERED ( Articles[Article] ), 1, 0 ),
    ALLSELECTED ( Deliveries )
)

and add this filter on the visualization
PLag_4-1677834636962.png

 

 

So, I want this view if nothing or all selected, 

PLag_0-1677834128824.png

 

But today it looks like; 

PLag_1-1677834172001.png

PLag_2-1677834196108.png

 

It in't possible to amend the filters - it's locked on cards.

PLag_3-1677834540781.png

 

Thanks and best regards, Pauline

1 ACCEPTED SOLUTION
andhiii079845
Solution Sage
Solution Sage

You are right. I am also not able to modify the measure in the filter pane in the card.

But you can but the measure directly in the card and modify the measure that it shows what you want.

Measure =
VAR _select = SELECTEDVALUE('Table'[year])
VAR _selectcount = IF(HASONEFILTER('Table'[year])=TRUE,_select,"")
RETURN _selectcount
andhiii079845_0-1677838441854.pngandhiii079845_1-1677838454222.png

 

 
 
 




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

1 REPLY 1
andhiii079845
Solution Sage
Solution Sage

You are right. I am also not able to modify the measure in the filter pane in the card.

But you can but the measure directly in the card and modify the measure that it shows what you want.

Measure =
VAR _select = SELECTEDVALUE('Table'[year])
VAR _selectcount = IF(HASONEFILTER('Table'[year])=TRUE,_select,"")
RETURN _selectcount
andhiii079845_0-1677838441854.pngandhiii079845_1-1677838454222.png

 

 
 
 




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.