Excel file shows lower value than Power BI

Question

Hi all,&nbsp;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.&nbsp;Went back to the excel, it showed 1996 and 1907 as well.&nbsp;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.&nbsp;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...&nbsp;&nbsp;&nbsp;&nbsp;Rgds,Felix&nbsp;

arul · Answer

x-File&nbsp;,
Can you share the sample data file? refer the image where you can add your files while you are replying,

Thanks,
Arul

x-file · Answer

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?

arul · Answer

x-File&nbsp;,
Share the screenshot of your data.
Thanks,
Arul

x-file · Answer

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

arul · Answer

x-File&nbsp;,
Where is that Beds Jan column?
Thanks,
Arul

Forum Discussion

Excel file shows lower value than Power BI

7 Replies

Related content

Matrix Hierarchy - Show blank rows at upper level but not lower level

Summary Table (SPC) showing NANs in columns Upper, Lower 99% Limit and Upper, Lower 95% Limit

Excel columns name not showing in PowerBI

Folded Matrix showing lower level value

Excel Subscription