Forum Discussion
Visuals either counting rows or appearing as matrixes.
Hello, I'm relatively new to Power BI but this is the first time I have this happen to me.
I've transformed my data into the data you see here (crossed cells are names) :
When I want to visualize it as a histogram :
I don't understand why the data shows up like that. I can't seem to find how to keep it from counting (agregating) the data.
Anyone has a clue ?
I answered myself while trying a few more things. The solution is of course simple.
The data types for variables "capacité", "affectation" and "capacité 23/03/31" were in the original form ABC123, so I changed the data types to "whole number", "decimal number" and "decimal number" in that order. It fixed the problem.
Now, instead of counting the number of "affectation" per "ressource", it shows the actual value of the "affectation" per "ressource".
Hopefully this can help other beginners solve their problems.
3 Replies
- ToddChitt
Super User
Change the Aggregation Type from Count to SUM:
Hello,
This was my first idea too, but since my data types were wrong, the only options I had while opening this menu were "Count (Distinct)" and "Count".
Thank you
I answered myself while trying a few more things. The solution is of course simple.
The data types for variables "capacité", "affectation" and "capacité 23/03/31" were in the original form ABC123, so I changed the data types to "whole number", "decimal number" and "decimal number" in that order. It fixed the problem.
Now, instead of counting the number of "affectation" per "ressource", it shows the actual value of the "affectation" per "ressource".
Hopefully this can help other beginners solve their problems.
