Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I am going through this tutorial https://support.powerbi.com/knowledgebase/articles/471597
The problem is that the UnitsInStock is always an aggregate. I cannot have individual values in the report. Only cout or sum etc. What step am I missing?
Solved! Go to Solution.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |