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
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.
Really appreciate you keeping the discussion alive Greg_Deckler.
Newp. I have "No Calculation" checked yet the % is still showing.
Ok so that wasnt helpful or answer the question in ant way
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,
DaleOh yeah, good call v-jiascu-msft, missed that he was using the 100% stacked column chart. ericOnline, you want the chart visual 2 to the left of the one you have now.
Wow. I feel pretty silly on that one! Thank you.
Did you get the output? I am having the same issue, help!!
Hi Anonymous ,
Greg_Deckler 's suggestions worked:
"
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.
"Ohh, I just missed the second page of the solution!
My problem is slightly different, but got it!!
Thank you anyways!