cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

Card not totalling correctly

Hi 

 

I have a report which looks at profitablilty by month and the profit is stored in a field called value.

 

Value is a whole number.

 

When I create a bar chart everything looks OK and when I filter the card is fine but when I dont filer the card displays a completely incorrect figure.

 

I've displayed both states below.

 

Thanks

 

Simon

 

Card Correct.pngCard Incorrect.png

1 REPLY 1
Super User I
Super User I

Hello @simonroyjones ,

 

What are you using in the card visual? Is it a measure or a column?

 

When no filter has been applied on the card, it displays the result for the entire table. 

 

What is the expected value on the card when no filters are applied?

 

Cheers!
Vivek

If it helps, please mark it as a solution. Kudos would be a cherry on the top 🙂
If it doesn't, then please share a sample data along with the expected results (preferably an excel file and not an image)

Blog: vivran.in/my-blog
Connect on LinkedIn
Follow on Twitter

Helpful resources

Announcements
November Update

Check it Out!

Click here to read more about the November 2020 Updates!

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform October Community Highlights

Check out the top community contributors across all of the communities

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors