Forum Discussion

zhilin's avatar
zhilin
Regular Visitor
4 months ago
Solved

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 

 


 

 
 
 
Need Help
Show and Tell
  • grazitti_sapna's avatar
    grazitti_sapna
    4 months ago

    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!

1 Reply

  • grazitti_sapna's avatar
    grazitti_sapna
    Super User
    4 months ago

    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!