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

Next up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. Register now

Reply
alibarcelona
New Member

New card does not show totalsales or quantity

Hi, 

I am working on a Power BI Project, when i insert a new card into dashboard, and select any value for exaple totalunits or total sales into data, card does not show any value, it just shows only 2 dashes.

can any one please help me to solve this issue, i have attached the screenshot.

 

thanks

AliError.png

5 REPLIES 5
alibarcelona
New Member

hi, 

Thanks for message.  now I am trying to insert measure in cards, it shows blank value. i am using these dax formula for measures.

TotalSales = SUMX(Sales_Data,Sales_Data[Units sold]* Sales_Data[Price per unit])
TotalTransaction = COUNTROWS(Sales_Data)
TotalCount = SUM(Sales_Data[Units Sold])
Blank.png
Thanks
Ali
Anonymous
Not applicable

Hi, @alibarcelona 

In your screenshot you are using the month Slicer, perhaps the problem is due to your Slicer settings being incorrect? This slicer may be excluding data. Ensure that the slicer is set up correctly to include relevant data.

 

If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. Thank you.

 

 

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

https://www.youtube.com/watch?v=znJGWMtk_EE&t=856s 

I am working on this project, i am trying to attach my Power BI project here but I did not see any option to attach the excel file or project. I am using new card to show the values or old card, but still does not show any values

DataNinja777
Super User
Super User

Hi @alibarcelona ,

 

To better assist you, could you please share the DAX measure you are trying to visualize? This will help in identifying any potential issues with the formula or the data context affecting the Card visual. Thanks!

 

Best regards,

Hi,

Thanks for reply.

now when i am triying to insert card values in dashboad, it shows Blank. i am using these dax formulas.

TotalCount = SUM(Sales_Data[Units Sold])
TotalSales = SUMX(Sales_Data,Sales_Data[Units sold]* Sales_Data[Price per unit])
TotalTransaction = COUNTROWS(Sales_Data)
Blank.png
Thanks
 
Ali
 

Helpful resources

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

Join our Fabric User Panel

Join our Fabric User Panel

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.

March Power BI Update Carousel

Power BI Community Update - March 2026

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