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
nataliesmiy1357
Helper III
Helper III

Report not connecting

Hello!  I have connected my PowerBI to a folder, but my data isn't connecting properly.  I tried to add my PowerBI to this fourm, but I wasn't able to.

 

Here are the problems...

1) The totals in my table are not actually adding the totals (See TMMAL -- 266+68 is not 266...) and then the totals on the bottom just are 0....

2) In the bar chart, that should be the totals for each line... and there is NO way that the total is over 30K.

nataliesmiy1357_0-1700150604274.png

 

3) When I used a filter to just show TMMAL - my September value should be 266 not 500something.

nataliesmiy1357_1-1700150691689.png

 

Just not sure what's wrong with my data/what I need to fix.  

 

1 ACCEPTED SOLUTION

Hi @nataliesmiy1357 

 

That is good to know.  

Can you do me a favour, create a simple measure for the column that you want to sum the amount:

Sum Amount = SUM ( 'Table'[ColumnName] )

 

Once you create this measure, just drag it into the Matrix visual where it says Values (or the Y Axis in your Bar Chart).

 

Please let me know the outcome.

 

Thank you.

 

Theo

 

If I have posted a response that resolves your question, please accept it as a solution to formally close the post.

Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!

Want to connect?www.linkedin.com/in/theoconias

View solution in original post

5 REPLIES 5
TheoC
Community Champion
Community Champion

Hi @nataliesmiy1357 

 

It sounds like your data sources may be of different type or format.  Just check that you have the same file type (i.e. CSV, XLSX, TXT, etc.) because if you have variable file types, Power BI will read the data differently.  In CSVs, the data is recognised as text, not values / numbers, meaning that you will manually have to ensure the data is formatted to values.  

 

The way that the values are formatted on the left of your visual typically flags that this is "Text" formatting, not numeric formatting.  So it may be worth clicking on the column in the Data pane on the right (your table and then the column of values), then go up to the main ribbon and click on "Column Tools".  In here, you can see Data Type on the far left. Ensure Data Type is "Whole Number" or "Decimal Number."

Let me know how it goes!

 

Theo

 

 

If I have posted a response that resolves your question, please accept it as a solution to formally close the post.

Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!

Want to connect?www.linkedin.com/in/theoconias

Hey - so I just checked and the files are the same (xlsx) and all of my numbers are number data types.  

Here is a screenshot of my data.

nataliesmiy1357_0-1700156641705.png

 

Hi @nataliesmiy1357 

 

That is good to know.  

Can you do me a favour, create a simple measure for the column that you want to sum the amount:

Sum Amount = SUM ( 'Table'[ColumnName] )

 

Once you create this measure, just drag it into the Matrix visual where it says Values (or the Y Axis in your Bar Chart).

 

Please let me know the outcome.

 

Thank you.

 

Theo

 

If I have posted a response that resolves your question, please accept it as a solution to formally close the post.

Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!

Want to connect?www.linkedin.com/in/theoconias

That fixed it!!!  Thank you so so much!

@nataliesmiy1357 You're more than welcome!  Have a great day! 🙂

If I have posted a response that resolves your question, please accept it as a solution to formally close the post.

Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!

Want to connect?www.linkedin.com/in/theoconias

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.

Top Solution Authors