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

The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!

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 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.