Forum Discussion

ericOnline's avatar
ericOnline
Post Patron
7 years ago
Solved

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 ...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    7 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Did you get the output? I am having the same issue, help!!

ericOnline's avatar
ericOnline
Post Patron
6 years ago

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.
"

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Ohh, I just missed the second page of the solution! 

    My problem is slightly different, but got it!! 

     

    Thank you anyways!