Forum Discussion
Helper IICannot have individual values in a chart. Values are always aggregate.
Hi Allan
I have not got time to look at your file. But what I suggest is you do this
Go into ----> Home / Edit Queries / Transform / Data Types
And see what Data Type your relevant columns have been set to
What I think is one is set as Text (UnitsInStock) and the other one as a value
You can see the difference below. One lineNumber I have set as text (Line Number) and one as a number (Line NumCopy). This is clearly shown by the symbol verse missing symbol between the tick box and the file name)
THE ONLY THING POWER BI CAN DO WITH TEXT IS A COUNT or countdistinct if its dragged into a value box. Thats why it shows as count'
Whereas a column set as a number format can be summed Averaged etc as shown below. (For some reason this does not show in the box as SumLineNumCopy. I assume the reason for this is to clealry show Text entries as opposed to non text entries)
So what you might need to do is change the UnitsInStock to a number format
If this isn't the issue someone else will have to help you out
Helper IIDo not summerize is the exact setup:
Helper III wish I could post the .pbix file here ...
- Greg_Deckler
Community Champion
OneDrive, put in the Everyone folder and post a link.
- Greg_Deckler
One other thought here, why wouldn't the sum aggregation work for this? I haven't looked at the data itself, but in theory, if you only have a single value for units in stock per product, then the sum aggregation is summing 1 value for each product, which would be the value you want. x*1=x?
If you had mulitple entries for that product, then wouldn't you want the sum as well so that you know about all of your units in stock? The filters you put in place would allow you to only get a single location, etc.??
- AllanXu
Here is the link to a pbix file that reporoduces the issue.
The goal here is underestand why PBI is not behaving the way that the tutorial explains. I like to underestand the root of the problem.
Thank you,
- AllanXu
Here is more information. I just need to underestand what is wrong with the field "UnitsInStock"
