Forum Discussion

fallguyxi's avatar
fallguyxi
New Member
9 years ago
Solved

Creating a line chart using non summarized values

I'm looking to do a simple line chart with a date range as the X axis, and the actual value of 4 different scenarios overlapping as the Y axis.  So data table looks something like this:   Month ...
  • fhill's avatar
    fhill
    9 years ago

     

    I copied and pasted your data into PowerBI, is this what you are trying to build?  My numbers are Whole Numbers instead of Decimals, but it shoudln't make a difference...    Un-hiearchy your date, does that help resolve the gropuing?  All my values are set to SUM, but that's OK b/c I have each date listed on the Axis.

     

    FOrrest

     

     

fhill's avatar
fhill
Resident Rockstar
9 years ago

 

I copied and pasted your data into PowerBI, is this what you are trying to build?  My numbers are Whole Numbers instead of Decimals, but it shoudln't make a difference...    Un-hiearchy your date, does that help resolve the gropuing?  All my values are set to SUM, but that's OK b/c I have each date listed on the Axis.

 

FOrrest

 

 

  • fallguyxi's avatar
    fallguyxi
    New Member
    9 years ago

    I guess removing the hierarchy does it.  More fundamentally though, i guess there's no way to actually choose not to aggregate data.

     

    Any chance you know how to get the X-axis to show more granularity?

     

    Thanks much for the assistance

     

     

    • fhill's avatar
      fhill
      Resident Rockstar
      9 years ago

       

       

      If you change the X-Axis Type to Categorial, it will list every value you provide (generally).  Remember to change your Date  Formatting to something like MMMM,yyyy so it's not overwhelming in length...  Hope this helps...