Forum Discussion
I fail with simple two-row data visualisation - please help
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
1 Reply
- greggybResident Rockstar
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".