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:

 

MonthBaseLargeModerateSmallFlat
10/1/2017250000250000250000250000250000
11/1/2017250000256780256780250000250000
12/1/2017250000266280266280259500250000
1/1/2018250000279594279594272475262500
2/1/2018250000279594279594272475262500
3/1/2018250000283094283094272475262500
4/1/2018250000283094283094272475262500
5/1/2018250000291594291594280975262500

 

It seems the line or area chart constantly summarize the columns of data in some way.  I've already ensured that in the modeling tab - all values are correctly formatted to decimal number or date as appropriate.

 

This is crazy simple in Excel as you can simply highlight the table and Insert - Line Chart, but I'd prefer to take advantage of the formatting capabilities of Power BI is possible.

  • 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

     

     

3 Replies

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