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

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

Greg_Deckler's avatar
Greg_Deckler
Community Champion
7 years ago

Strange, any way that you can share the PBIX file or provide sample/example source data?

  • ericOnline's avatar
    ericOnline
    Post Patron
    7 years ago

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

    • Greg_Deckler's avatar
      Greg_Deckler
      Community Champion
      7 years ago

      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.

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