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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
Mrecords
Frequent Visitor

Shape map: card displaying "ALL" when nothing is selected

Hi all, 

 

I am using Shape Map with various provinces and a Card that shows me the name of the selected province.

Now when no province is selected I can choose to see the name of the First or the Last province, but what should I do to display the text "All" in the Card when no Province is selected? 

 

Thanks!

 

1 ACCEPTED SOLUTION
mbolognesi
Frequent Visitor

You can adapt this proposed by Vvelarde:

 

View solution in original post

 

First measure would be: 

FilterProvince = ISFILTERED ( Table[Province] )

This measure returns FALSE when no province is selected and TRUE when one is selected.

  

Then you can create a measure to show in a card the name of the selected province or the text "all" when no province is selected, like this:

 

ShowProvince = IF ( [FilterProvince], SUMMARIZE(Table, Table[Province]), "all")

 

View solution in original post

1 REPLY 1
mbolognesi
Frequent Visitor

You can adapt this proposed by Vvelarde:

 

View solution in original post

 

First measure would be: 

FilterProvince = ISFILTERED ( Table[Province] )

This measure returns FALSE when no province is selected and TRUE when one is selected.

  

Then you can create a measure to show in a card the name of the selected province or the text "all" when no province is selected, like this:

 

ShowProvince = IF ( [FilterProvince], SUMMARIZE(Table, Table[Province]), "all")

 

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

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

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

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.

Top Solution Authors
Top Kudoed Authors