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

ericOnline's avatar
ericOnline
Post Patron
7 years ago

Really appreciate you keeping the discussion alive Greg_Deckler. 

Newp. I have "No Calculation" checked yet the % is still showing.

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!