Forum Discussion
HELP: Line chart VALUES NOT COUNTS!
I'm having trouble here. Not sure what I'm missing.
Scenario:
- Two tables; both have exact same column names
- One table is forecasted values, other is actual values
- Relationship screen shows 1-to-1 for both tables
- There is a date column; both tables have the same dates
- There is a temperature column; each table has different temps and I want to show the difference between tables
I can't figure out how plot the differences between the two charts on a line or stacked bar chart! When I pull temperature column of one table to the "Value" field of the visual, I get a "Count of Temperatures". I don't want a COUNT, I want to see all temperatures over the time period.
So then I drag the time column to the "Axis" field of the visual. Cool, I get a time scale along the x axis with "100%" showing for each temperature COUNT.
Basically, how do I change the visual to show me the VALUE of the temperature column over time instead of the COUNT of temperature readings?
Thank you!
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
23 Replies
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.
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.
Carlw Keep pushing it, we have no choice.
Yes, don't use it. Every once a year I try and create a graph or scrape some data. Invariably, i.e. EVERY TIME, there's an issue. Oh you can only do this if it's a Tuesday with a full moon. Any errors don't provide any useful feedback.
It's like the std msft way of describing things. For example: "to perform or implement function "x", turn on your computer, select the software and implement said function". Wow was that ever helpful!!
So no I can't be bothered with BI right now.
For anyone still looking at this problem, I resolved this same issue by changing the summarization to SUM under properties with the y-axis value I wanted. I then added the y-axis value to the line graph as the Sum of "value". If the values are distinct across your x-axis, then you'll see the actual value populate on your graph.
This is the answer I was looking for...Thank you VERY much.
