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

July 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more

Reply
Jayfemi
Helper I
Helper I

Card Visual Fields

so i have a column with a list of areas when i put it in a card Visual i get the following options when selecting a field.

 

First

Last

Count

Count (Distinct)

 

Can i decide what it says for First and Last ideally i would want it to say All areas?

1 ACCEPTED SOLUTION
v-sihou-msft
Microsoft Employee
Microsoft Employee

@Jayfemi

 

In a Card Visual, it can only display a single value, which means if you put a data field column, it must aggregate. Since you put a text column, it can only aggregate in First, Last, Count and Distinct Count. If you want to display all entries, you should use Multi-row Card. 

 

6.PNG

 

Regards,

View solution in original post

2 REPLIES 2
v-sihou-msft
Microsoft Employee
Microsoft Employee

@Jayfemi

 

In a Card Visual, it can only display a single value, which means if you put a data field column, it must aggregate. Since you put a text column, it can only aggregate in First, Last, Count and Distinct Count. If you want to display all entries, you should use Multi-row Card. 

 

6.PNG

 

Regards,

vanessafvg
Community Champion
Community Champion

@Jayfemi  you can  only put one value in a card, that is why it wants you to choose one  - can i ask you why you using a card and what are you trying to do





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




Helpful resources

Announcements
FabCon and SQLCon Barcelona 2026

FabCon & SQLCon – Barcelona 2026

Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.

60 days of Data Days Carousel

Data Days 2026

Join Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

Top Solution Authors