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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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!


LinkedIn


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!


LinkedIn


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!


LinkedIn


Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.