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

Level up your Power BI skills this month - build one visual each week and tell better stories with data! Get started

Reply
zhilin
Regular Visitor

Card visual shows blank while the table has data

I have a mesure like below

Budget = SUM('Acquisition Forecast'[budget_lcy])
 
when I try to visualize it in a card visual, it turns blank . but actually we have numbers in the colonne [budget_lcy] of table 'Acquisition Forecast'.
 
the table is like this 
zhilin_1-1776068320239.png

 


 

 
 
 
1 ACCEPTED SOLUTION
grazitti_sapna
Super User
Super User

Hi @zhilin,

 

Please check as below:-

 

1. Check if any Report/page/visual level filter is applied on KPI card

2. Creat a measure to count rows using column 'Acquisition Forecast'[budget_lcy], if the count is >0 then proceed next 

3. Check data type of the column, if it has any test values, alphanumeric values or nulls then Power BI consider it as text so aggregation doesn't happen, make sure the data type is correct

4. Check for the relationships should not be inactive/wrong direction/filtering out data

 

🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
🔗 Curious to explore more? [Discover here].
Let’s keep building smarter solutions together!

View solution in original post

1 REPLY 1
grazitti_sapna
Super User
Super User

Hi @zhilin,

 

Please check as below:-

 

1. Check if any Report/page/visual level filter is applied on KPI card

2. Creat a measure to count rows using column 'Acquisition Forecast'[budget_lcy], if the count is >0 then proceed next 

3. Check data type of the column, if it has any test values, alphanumeric values or nulls then Power BI consider it as text so aggregation doesn't happen, make sure the data type is correct

4. Check for the relationships should not be inactive/wrong direction/filtering out data

 

🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
🔗 Curious to explore more? [Discover here].
Let’s keep building smarter solutions together!

Helpful resources

Announcements
April Power BI Update Carousel

Power BI Monthly Update - April 2026

Check out the April 2026 Power BI update to learn about new features.

Fabric SQL PBI Data Days

Data Days 2026 coming soon!

Sign up to receive a private message when registration opens and key events begin.

New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

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.