Forum Discussion
Report not connecting
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
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
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.
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
That fixed it!!! Thank you so so much!
