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 fail with simple two-row data visualisation - please help
I may import data by CVS so that I have a table in PowerBI:
Headline:
name data
one 1000
two 2000
three 3000
but I fail with the visualisation by bars ( and any other graphics )
Stacked Bar Chart
Axis -> name
Value -> data
but the only option is "count of DATA"
which means that my graphics has the right horizontal axis decription ( one, two, three ), but... the ONLY option for value is "count of DATA", so that the value is 1 for each of the data items, instead of 1000, 2000, 3000.
so the graphics is
one xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx (1)
two xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx (1)
three xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx (1)
with value 1
what I expect ( from my experience with Microsoft Excel, OpenOffice Calc,..) is
one xxxxxxxxx (1000)
two xxxxxxxxxxxxxxxxxxx (2000)
three xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx (3000)
before, I tried to visualize this data with SPLUNK
where I had "similar" problems to visualize this kind of data, but there the option "sum" ( instead of "count" ) helped.
I am frustrated, as the data is so simple,
what am I doing wrong, or what am I expecting wrong?
Any help is appreciated.
The original data is about the number of certain first names ( e.g. "Maria" ) given to new born babies in a state, and the number of children named with 1,2,3 or more first names... so its quiet simple open data.
Sincerely
Rolf
Change the type of your data to Whole Number under the Data Modelling ribbon menu (available when you have a field selected), and make sure that the Default Summarization is not set to "Do not summarize".
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 |
---|---|
111 | |
94 | |
83 | |
67 | |
59 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |