Forum Discussion
HELP: Line chart VALUES NOT COUNTS!
Hi ericOnline,
Why did you use the 100% Stacked Column Chart while you don't like the % columns? Maybe you can use another visual instead. If you can share a sample file, please upload it to the cloud drive like OneDrive, GoogleDrive, then share the download link here.
Best Regards,
Dale
Generally you get this behavior because your column is of type Text and you probably don't want that. Check your data type. If it really is a number, you can drop down the little arrow for the column in the Values area and change the aggregation.
No, you can't do squat.
We can talk about slicing and dicing all we want. Fact is Power BI is making far too many assumptions and playing games. I went far in my schooling in a scientific field. Whenever we make a bar graph, or line graph or a giraff, YOU PRESENT YOUR X-AXIS AND Y-AXIS VALUES. Nobody asked for PowerBI to do this, and its not even intuitive on how to turn that mess off. What it looks like is kids that can program and then show that they set up this tool, not the way real people actually use data but with snazzy filters, from the get go. NO ONE WANTS THAT AT THE BEGINNING. HOW WELSE ARE YOU SUPPOSED TO VERIFY THE DATA??????????????????????????????????????????????????????????????????????????????????
This is how I feel every time I try to do anything in power bi. It's incredible how poorly designed it is.
Here's another example of how bad power bi is:
I only use it because I am forced to for my job. I will never recomend it to anyone ever.
I hear you. It's all so bad that this is the second time trying to respond. First time a box popped up asking if I'd like to give feedback. It blew away everything I wrote and took me to another page. WTF?????!!!!
Yes for sure I will up my subscription for the pro version now. NOT
Hi Greg_Deckler, thank you for the reply.
I changed the dataType to decimal number and am having similar behavior. Dragging the "temperature" column to "Value" gives me a SUM this time instead of a COUNT (same thing?).
If I click the dropdown next to "temperature" the only options are SUM, AVERAGE, MIN, MAX, COUNT(distinct), COUNT, STANDARD DEV, VARIANCE, MEDIAN.
Where is "VALUE OF THE ACTUAL FIELD"?
Well, if you have your axis granular enough to display at the individual row level, then SUM, AVERAGE, MIN, MAX, etc. don't matter (except for COUNT, COUNT bad), they are all the value of that specific row. In certain settings, you will get a "Do not summarize" option, but that is not for all visuals.
Hm. The Y axis is labeled "%", and each measure is "100%" which makes no sense to me! Each of these should be a temperature value. Each values in this column is a temperature measurement (EX: "48.99", "48.00", etc.).
