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
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.).
YOU SHOULDNT HAVE TO SHARE ANY REDICULOUS. YOU SIMPLY WANT A SIMPLE GRAPH DISPLAYING THE DATA. NO PERCENTAGES, NO SUMS NO PERCENTAGES. THE DATA!!!!!!
The reason people say that is they probably have never used real data in their life and just know how to play around with these programs, which BTW is badly setup therefore.
Strange, any way that you can share the PBIX file or provide sample/example source data?
Sure.
Attached is the .pbix file.I don't have the "Add Attachments" button when replying. Here are some screenshots that show the issue:Data:
- Temp: decimal
- ObservedTime: dateTime
Stacked Bar Chart Vis:
- Temp: Value
- ObservedTime: Axis
- YAxis showing as "%"
OK, here is what I am guessing, at some point you clicked the little drop down arrow for your value and chose "Show As" | "% of Grand Total". Turn that off.