cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
x-File
Helper I
Helper I

Excel file shows lower value than Power BI

Hi all,

 

See attached. I monthly compare Planned and realized values.

For january '23, there was apparantly some 2011 planned, and 1929 realized, according to the excel AND the left graph. This was the original. When I loaded the excel into another file, it showed 1996 and 1907. Went back to the excel, it showed 1996 and 1907 as well.

 

Now, for a test, I went to the original pbiox file, also loaded Table 1 (which is the same as Table 'Beds Comparison'), it shows 1996 and 1907. Though both tables in Query Editor contain the same values etc.

 

Could somebody help me? To make it more diffcult: 2011 and 1929 are the right values, though my excel doesn't show them.

I'm happy to email/add the files however this forum won't let me... 

 

diff values.JPG

 

 

Rgds,


Felix

 

7 REPLIES 7
x-File
Helper I
Helper I

HI @Arul , 

Could you please respond to my personal message to you? Thanks in advance!

 

Rgds,

Felix

x-File
Helper I
Helper I

Beds Jan.JPG

Beds Janm 2.JPG

Beds Jan Table 1.JPG

   But could I email you? That would make it more eaey for the both of us I think?

@x-File ,

Where is that Beds Jan column?

Thanks,

Arul





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




It isn't in, it's what the file is called. I use the Totaal Column in Excel, or in power Bi a custom column that adds ochtend+middag+avond+nacht.

x-File
Helper I
Helper I

It can't. In my account, it doenst show your attached option somehow. Also, it shows this red bar when dragging something here. Could I email it?

doesntwork.JPG

@x-File ,

Share the screenshot of your data.

Thanks,

Arul





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Arul
Super User
Super User

@x-File ,

Can you share the sample data file? refer the image where you can add your files while you are replying,

Arul_0-1676977645229.png

Thanks,

Arul





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors