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

Different results on multi-row card

I have shown several measures on a multi-row card. This works when the source is an Excel-file. However, I get different results when the source is a SQL Server (which contains the same data as the Excel-file). Does anyone know what the problem might be and how I can solve it? Thanks in advance!  

3 REPLIES 3
Moderator Eric_Zhang
Moderator

Re: Different results on multi-row card


@MO wrote:

I have shown several measures on a multi-row card. This works when the source is an Excel-file. However, I get different results when the source is a SQL Server (which contains the same data as the Excel-file). Does anyone know what the problem might be and how I can solve it? Thanks in advance!  


@MO

What are the different results, could you show some snapshots? I'm not able to reproduce this issue, will you upload one pbix file with excel data and another with data from SQL Server? You can upload pbix files in web storage like Onedrive and share me a link in a private message. Do mask sensitive data before uploading.

MO Frequent Visitor
Frequent Visitor

Re: Different results on multi-row card

@Eric_Zhang Thank you, I have already solved the problem. It had something to do with historical data. 

Moderator Eric_Zhang
Moderator

Re: Different results on multi-row card


@MO wrote:

@Eric_Zhang Thank you, I have already solved the problem. It had something to do with historical data. 


@MO

Do you mean that the visual works fine, the difference is caused from the data inconsisitence between Excel and SQL Server?

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)