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

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

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
September Power BI Update Carousel

Power BI Monthly Update - September 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.